Hi all! I'm looking for some help with this one.
I have a spreadsheet that has data I'm trying to send out to different recipients and include an attachment that is also referenced in the spreadsheet...i.e:
A B C D E F recipient email celldata1 celldata2 celldata3 celldata4 PDF attachment file location (file differs based on results in celldata4)
The macro would use the recipient email to send celldata 1-4 as part of the body of the email and also include the PDF attachment in the email. I would estimate the total emails sent from this procedure to be somewhere between 25-50 daily.
I've seen where this is possible, but from what I've seen, as either you name the attachment location in the code, or Excel can send a range of data as an attachment. I haven't found anything that will instruct Excel to add an attachment that is referenced within the spreadsheet.
Can anyone assist me with this?
Thank you in advance,
soundkeyz
Bookmarks