Help converting single recipient email macro to limitless

I want to be able to add multiple email addresses and have the macro send a separate email for them all. Don't ask why not a single with multiple recipients, I do not know, I am helping someone else out.

How much more difficult would it to instead reference another workbook, "Addresses" and so if the email addresses need to be adjusted that workbook can be opened instead of the macro?

Please Login or Register  to view this content.

My apologizes. it would be microsoft outlook 2016.

I found out more about the process later yesterday, person I am helping will download an excel file from our software and then use the addresses that are in that file to send the emails to. Is it possible to have a location box pop up asking for the file in order to pull the addresses? So they would download a file, then in this spreadsheet they would run the macro, select the download location of that other file and it would pull those emails? If that is far more complicated then that is ok, they can open the downloaded file and copy/paste into their own.



And just in case anyone is concerned, this is not spam! lol. This is in direct and immediate response to a request.

Idk if I can one "bump" a thread or not..

Thanks sintek! Since we are using 2016, would that change anything?

So I opened a spreadsheet and ran the macro and the only thing it emailed was a blank email with "this is a test" in the subject, nothing in the body other than my signature.