Create outlook email with text, subject and recipient based on cells in worksheet

[KingKahnV]

Hi

Please can someone help me with some code that will open an email in outlook to email address in column D.
From an email address in B1.

with text along the lines of

Hi (Name in column C)

Please find attached your (Month in A1) document for (company in B)

regards

KingKahnv

I will need to manually attach each doc as there is no link between doc names and the file, and then send the item.

Preferrably I would like the code to create one email at a time based on the row/cell highlighted.

thanks

KingKahnV

 

[Comfy]

This will help:

Mail from Excel with Outlook (VBA)

It should have everything you need.

 

[robgoldstein]

If all the information is in the spreadsheet is there a reason you can't simply do a mail merge? https://www.youtube.com/watch?v=wozo9KGAdAw

 

[KingKahnV]

Hi, thanks, I have most of what I need, please can you tell me how to set a from email address?

 

[robgoldstein]

Here is a link from the list posted by comfy Use the mail account you want in your mail macro