VBA Email; Send a specific Sheet to a specific Email Address

[FelixSall]

Hi There,

I'm new to this forum so please redirect if i'd post in the wrong area.

With that said im currently stuck on figuring out how I could arrange an automated email process via Excel and Outlook.
I've come so far that I managed to create an email list and generate a given Subject + Body and send these to a given email address according to my list.

My query and ambition is that I could add attach a given sheet per email address.

My setup is like this:
Column A: Email list, Column B: Name, Column C: Body (with replace_name)
Now how can I arrange so that in theory: The first email will use the address in A1, the name in B1 and the body in C1 and THEN attach the sheet called "DC_1" (in the same workbook)
and for the next email A2, B2, C1 + attach sheet "DC_2"

Sorry for grammar errors (I'm Swedish )

 

[ranman256]

There should be an email button on the spreadsheet.
click it to send it thru email.

 

[FelixSall]

Well, the point is that there are 16 different sheets and each one of the sheets are supposed to go to a specific email address.
OFC I could send just the sheet and manually type in their emails address.

But doing that each month is something i'd like to avoid - hence the thread....

 

[daverunt]

Hi,

I would look at Rons site. It should point you in the right direction.

https://www.rondebruin.nl/win/s1/outlook/mail.htm