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]

Hi RyanJ1991,

Welcome to the MrExcel Board.

I have to ask... Have you tried researching this at all. This question has been covered at length on this board, and there is a ton of information on the internet as well. The link that follows is a search of MrExcel.com...

https://www.mrexcel.com/forum/search.php?searchid=7821194

 

[Fluff]

@igold
Have you tried following the link you supplied

 

[igold]

Hi Fluff,

Yes, I pasted it to an email and sent it to myself and it worked fine.

Is it not working as posted on the forum...

I just tried it again and it works...

 

[Fluff]

When I click the link I get this message

Sorry - no matches. Please try some different terms.

 

[igold]

Interesting.

After your reply I went into Post #2 and tried it and it worked.

Perhaps it is some sort of message board dysfunction that it works for me because I authored it.

Either way I hope that the OP understands the point I am trying to make.

 

[RyanJ1991]

I get the same message. I have researched it everywhere and I can't seem to find out how to attach the files. I get the adding messaeg subject etc the attachments field seems to be giving em a hard time.

 

[igold]

Hi Ryan,

I just recently was helping someone with emailing attachments. Here is that link which should work. If it doesn't please post back that info...

https://www.mrexcel.com/forum/excel-questions/1060294-email-individual-attachments.html

 

[igold]

@Fluff

When I click the link I get this message

Maybe you could test this out. Do a search, copy the results link, post it, and see if you can open it and if anyone else can open it.

It would be nice to know what is happening for future reference...

 

[Fluff]

Can either of you see this list
https://www.mrexcel.com/forum/search.php?searchid=7821326