Help required for sending emails to various address through VBA code

[anbub1]

Experts,

Good Day. I have some files in D:\test and I need to send these files as attachments to different recipients as per the list attached in the excel file. For files AAA, BBB,CCC etc., in col A, email should be sent to their respective recipient of col C and and CC to col D and bcc to col E. Subject and body of the mail will be same for all mails. Subject of the mail will be cell F2 and body of the mail will be range F3 to F8.

Thank you.

[scott.s.fower]

assuming you have outlook
try this

if you need the body on separate lines change & " " & to & chr(13) &

see note next to the file attach part, i can't quite get that

Please Login or Register  to view this content.

[anbub1]

Thanks Scott,
Sorry for delay in reply. I tried with your code. file attachments are not getting done. Even after removing attachment line, ".Send" is showing error. "Outlook does not recognize one or more names" message is coming. Did u managed it when you are executing this code?