Send Bulk Emails With Excel Range on Mail Body | Advanced VBA in Hindi
HTML-код
- Опубликовано: 11 сен 2024
- Send Bulk Emails With Excel Range on Mail Body | Advanced VBA in Hindi
🔴 Subscribe for more videos just like this: bit.ly/2PUQwXk
🎧In this video, you will learn
► Send Bulk Emails with excel range on mail body
► How to send bulk emails in vba
► How to copy range to mail body and send mail
Hope you found this video useful. Please like, share, and subscribe to our channel. This will motivate us to create more good content. Thanks!
🎬Watch our most recent videos: / automationfever
💜You Might be Interested in (Free Tutorials):
Basic VBA Tutorials (Hindi)👉 • Why Should Learn VBA |...
Advanced VBA Tutorials (Hindi)👉 • Send Outlook Mail in V...
Excel VBA Projects (Hindi) 👉 • Add & Change Sheet Tab...
VBA Outlook Automation (Hindi)👉 • Send Outlook Mail in V...
Excel Tips & Tricks (Hindi)👉 • Copy From Clipboard - ...
How to copy multiple ranges on email body👉 • How to copy multiple r...
➖〰➖〰➖〰➖〰➖〰➖〰➖〰➖〰➖〰➖
🎧Do watch our Other VBA Videos (Hindi) 👉
Schedule a mail to send later 👉 • Schedule a mail to sen...
Move Emails From One Folder To Another 👉 / 96xwq4i0z1
Auto Reply On Email With Template 👉 • Auto Reply On Email Wi...
How to send pivot table on mail body 👉 • How to send pivot tabl...
➖〰➖〰➖〰➖〰➖〰➖〰➖〰➖〰➖〰➖
-------------------------------SOCIAL-------------------------------
🛠️ If you have any doubt or query, drop us an email: queries.automation@gmail.com
🌎Website: www.automation...
👥Facebook: / feverautomation
🐦Twitter: / automationfever
📸Instagram: / automationfever
📕Blogger: automationfeve...
🌎WhatsApp : +91 93100 73387
----------------------------------------------------------------------
#BulkEmails #VbaBulkMailSend #VbaOutlook #VbaAutomation #AdvancedVba #OutlookAutomation #VbaTraining #AdvancedVba #ExcelVba #LearnVba #AutomationFever #ShaanAnsari
Useful Video as usual.. Keep it up Sir..
Thank you, I will
You are really genius man, this macro help me lot
Thanks! I'm glad the macro was useful for you.
Sir how to add default signature on it. Very usefull content sir. Thank you
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.
Nice video ❤
Thanks 🤗
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.
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?
This is really nice. could you also share how I can add Cc and Bcc
too good
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
Well done 👍 great job 👏... Could you put this sheet in comments ❤
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
Can you please suggest how to past excel range data in outlook with autofit with contents
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
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
@Automation Fever can I get this code in text format or do I need to write it down manually ?
Sorry for responding so late.
Please fill out the following form, and our team will provide you the code forms.gle/CnnDpYBaRHoGwCeZ9
Sir macro code daldo
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
please provide me the solution
same with me. Any solution?
Dear Sir,
Could you please provide the excel file with videos, it can help us to learn easily.
This code is not working.. I'm getting Syntax error
Can you Please send me excel macro
Typed same code but getting error ,object missing
.Runtime error 424
Any background mail option by VBA, foreground m wait karna pad raha hai.
Almost I have to sent 100 mail.
same cheez kya gmail me kr skte hai kya
Gmail ki email ko aapko Outlook me configure karna hoga fir aap aesa kr payege
Iske liye koi delicated vedio hai apka
sir how to write the EMAIL BODY
How to insert button send regionwise shortfall
in excel file?
Sir isme cc bhi karna ho to kisi ko
cc property ka use krna hoga same aese hi jaise To property ka kiya hai
Doc.Range.Characters.Last.Paste
Run Time Error 4198 Command Failed
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
Can you mail the file
Sir send vba code fir this