Very Precise and Useful Video. This helped me to automate my bulk emails. Sir, need you help for next level of automation which can take multiple table range in Mail body from multiple sheets.
@ChandanaDas-xi8og
Жыл бұрын
Sir how to add default signature on it. Very usefull content sir. Thank you
@akshaygawale8079
Жыл бұрын
Thank you so much Sir! Very useful! But I am getting error “runtime error 287 : Application defined or object defined error “ Can you please guide me?
@abhinavsrivastav5332
15 күн бұрын
Which code to use to fetch data from Dropdown List in alternative to filter function?
@sivanandpottabathini118
3 ай бұрын
Very useful video.Sir, can you do 1 video on automated mails using If condition,If condition pass mail send to 1group of people else rest ofbthe group.
@harshadbarot
11 ай бұрын
You are really genius man, this macro help me lot
@AutomationFever
10 ай бұрын
Thanks! I'm glad the macro was useful for you.
@gulrezmansoori-nq1op
3 ай бұрын
This is really nice. could you also share how I can add Cc and Bcc
@KuldeepSingh-nq1vi
Жыл бұрын
Useful Video as usual.. Keep it up Sir..
@AutomationFever
Жыл бұрын
Thank you, I will
@Vaibhav21May92
Жыл бұрын
@Automation Fever can I get this code in text format or do I need to write it down manually ?
@AutomationFever
9 ай бұрын
Sorry for responding so late. Please fill out the following form, and our team will provide you the code forms.gle/CnnDpYBaRHoGwCeZ9
@nirmaleshrahate6871
5 ай бұрын
Very usefull great work sir Bu I have 1 question If in report sheet have no data available and same time I data sheet have available Then how resolve error
@aamirkhan-hi1qk
9 ай бұрын
Vedio is very useful, And we have applied the same steps but we are facing the problem in writing code. So please share the code
@AutomationFever
9 ай бұрын
I appreciate you watching the video and leaving comments. Please fill out the following form, and our team will provide you the code forms.gle/CnnDpYBaRHoGwCeZ9
@SKumar-tw8jj
Жыл бұрын
Can you please suggest how to past excel range data in outlook with autofit with contents
@АхмедЭлкади
Жыл бұрын
Well done 👍 great job 👏... Could you put this sheet in comments ❤
@AutomationFever
Жыл бұрын
Please find the code below Sub SendRegionWiseReportOnEmail() Dim OutApp As New Outlook.Application Dim mail As Outlook.MailItem Dim doc As Word.Document Dim r As Integer If (Sheet1.AutoFilterMode = True) Then Sheet1.AutoFilterMode = False End If For r = 2 To Sheet8.Cells(Rows.Count, 1).End(xlUp).Row Set mail = OutApp.CreateItem(olMailItem) With mail .BodyFormat = olFormatHTML .Display .To = Sheet8.Range("C" & r).Value2 .Subject = Sheet8.Range("D" & r).Value2 Set doc = .GetInspector.WordEditor Sheet8.Range("E" & r).Copy doc.Range.Paste doc.Range.Characters.Last.Text = vbNewLine Sheet1.Range("A1").CurrentRegion.AutoFilter _ Field:=2, _ Criteria1:=Sheet8.Range("B" & r).Value2 Sheet1.Range("A1").CurrentRegion.SpecialCells(xlCellTypeVisible).Copy doc.Range.Characters.Last.Paste Application.CutCopyMode = False doc.Range.Characters.Last.Text = vbNewLine & vbNewLine & _ "Best Regards," & vbNewLine & _ "Shaan Ansari" '.Send End With Next r Sheet1.AutoFilterMode = False End Sub
@LearningPower-bh8tl
Жыл бұрын
Nice video ❤
@AutomationFever
Жыл бұрын
Thanks 🤗
@Shunno990
Жыл бұрын
Dear Sir, Could you please provide the excel file with videos, it can help us to learn easily.
@MohitTayal-p9c
Жыл бұрын
Hi the Sheet10.Range("B1").CurrentRegion.AutoFilter Field:=2, Criteria 1:=Sheet3.Range("A2").Value2 gives me the error for filter the data please help
@MohitTayal-p9c
Жыл бұрын
please provide me the solution
@kapiljagdale
Ай бұрын
same with me. Any solution?
@NiteshPandey-xd9dt
6 ай бұрын
Any background mail option by VBA, foreground m wait karna pad raha hai.
@NiteshPandey-xd9dt
6 ай бұрын
Almost I have to sent 100 mail.
@sanjanamhatre8926
3 ай бұрын
This code is not working.. I'm getting Syntax error
@ramkshetty
4 ай бұрын
too good
@shortvedioa786
7 ай бұрын
same cheez kya gmail me kr skte hai kya
@AutomationFever
6 ай бұрын
Gmail ki email ko aapko Outlook me configure karna hoga fir aap aesa kr payege
@shortvedioa786
6 ай бұрын
Iske liye koi delicated vedio hai apka
@SonuSingh-lu8qd
2 ай бұрын
Can you Please send me excel macro
@amarendrahaloi2564
Жыл бұрын
sir how to write the EMAIL BODY
@I5EEYOU
Жыл бұрын
Doc.Range.Characters.Last.Paste Run Time Error 4198 Command Failed
@AutomationFever
Жыл бұрын
This usually happens when an incorrect line of code compiles into the source code of the program. Do one thing, use later binding and try again
@SachinKumar-zt6fy
8 ай бұрын
Sir isme cc bhi karna ho to kisi ko
@AutomationFever
7 ай бұрын
cc property ka use krna hoga same aese hi jaise To property ka kiya hai
@aniljadhav5971
Жыл бұрын
How to insert button send regionwise shortfall
@AutomationFever
Жыл бұрын
in excel file?
@bharatmakwana4345
2 ай бұрын
Sir macro code daldo
@sameerwagh409
Жыл бұрын
Sir send vba code fir this
@gupta556
6 ай бұрын
Can you mail the file
@philyu736
2 күн бұрын
Microsoft design the worst outlook objects model . so many bug! display method is a bug. use word document as outlook html body is a big mistake.
Пікірлер: 46