Send different emails to different email ID"s from Excel

[Sumit Dey]

Hi everyone,

I know how to send emails to several emails ID's at a time using VBA... But, I am looking to send different emails to each email ID/ID's at once. Like we do in a mail merge.

Currently I am using mail merge whereas, some sections of the email are fixed and are taken from an word file but, some other parts of the email had to be different and here we use the data from an excel file. We merge data from the word file and the excel file and send them all at once.

I would be thankful if someone can find an alternate way of doing the same using the Excel vba alone.

Thanks a lot in advance

 

[Sumit Dey]

Use a loop through a range of cells with the fullpath to the files or in this example selected files.

.Body = ""

AttachFileName = Application.GetOpenFilename("Files (*.**)," & _
"*.**", 1, "Select File", "Open", True)

For i = 1 To UBound(AttachFileName)
.Attachments.Add AttachFileName(i)
Next

.Display

End With

Thank you so much again. Shall I simply replace this code in place of the code I used?

One more thing I am using an excel sheet from where my macro would fetch data to send emails. The Excel sheet have fields columns like -To, CC, Body, Attachments,etc I simply add data in the respective rows and the macro fetch these data to send mails.
I would like one more help ... if possible is there any code wherein, I can also used formatting like fonts, color , font sizes etc.

 

[daverunt]

Yes. Between the .Body and .Display as shown.


There are a couple of ways to do the formatting both require using .HTMLBody instead of .Body, which sends an html formatted mail instead of a text formatted.
The function RangetoHTML from here:
https://www.rondebruin.nl/win/s1/outlook/bmail2.htm
will copy a range of cells to the body with the formatting from Excel intact.

The other method is to add html tags to the email code with inline style for the text you want to format.
The content of the sheet in this case need not be formatted as it would be done by Outlook interpreting the html

Have a look at the link.
If you have problems just come back (and post all your updated code).

 

[Sumit Dey]

Closed.. thanks everyone