VBA to add attachments to email based on list

[RyanJ1991]

Hi, I've been looking into writing VBA code to send an email with multiple attachments which are found in the sheet Pending Tom Review and begins in cell R7 and can be up to 20 attachments (R27).

The .To should be found in "A1"
.cc "A2"
.subject "A3"
.Body "A4"

Please help !!!!

Thank you

 

[igold]

Nope.

Can you.

 

[Fluff]

Yup
Maybe it's something to do with cookies

 

[igold]

I just cleared all my MrExcel cookies, logged out, logged in (had to re-enter my password), and my posted search link still worked for me.

 

[Fluff]

Just tried using a different browser.
Before logging in my link didn't work, but after logging in it did.

 

[igold]

I guess somehow the mechanics of the message board somehow intimately ties the search to the search author...

 

[Fluff]

Guess so.
@RyanJ1991
For all things email the best place to look is Ron's site https://www.rondebruin.nl/win/s1/outlook/mail.htm

 

[RyanJ1991]

Thank you for all the help guys! When I get home I will try out your suggestions

 

[igold]

Good luck. The link that Fluff provided is the "go to" page for emailing via Excel...