Hello everyone.
Often I have to send hundreds of emails.
From a Excel list, with the following data columns. Name; Email; Subject; Text; File.
Then I send an email for each line with that data, and attach a specific .pdf document from a specific folder.
The emails must be sent from a specific, " From " email, my own. So IŽd like to add that directly to code, instead of creating a entry in Excel, since it's always the same email.
The " Email " column data goes to the " To " field in email.
The " Subject " column data goes to the " Subject " field in email.
The " Name " Cell data goes into a specific place in the email, to complete a sentence like
" Dear Mr/Mrs <Cell A2 Data> ".
The " Text " column data goes to a specific place in the email body to complete a sentence, just like the " Name " example given above.
Let's say: " Thank you for acquiring "<Cell D2 Data>. Any problems please reply to this email. ".
The " File " column is where the file name is. For example "12345.pdf". This is the tricky part ( for me ... ), which I don't think is possible.
For each line, I have a specific .pdf file, and I want the macro to read that cell, and from a folder, pick that file and attach it to the email, then send the email.
Firstly, I'd like to know if getting this automatic is even possible.
Secondly, if it's possible, can someone please help me?
Thank you for your time.
I'm using Excel and Outlook 2007.
Darker
Bookmarks