Email excel file to list of recipients in the excel file

We have excel reports that list 4 email addresses in certain field and this excel file has to be emailed to all those people every time it is changed. I am not particularly skilled in VBA but is there a way to have:

1. the user initiates the process (click a button, macro, etc)
2. It opens an email in outlook with the excel file attached.
3. The subject line, message body, To: addresses, are all prefilled in from particular cells in the file. (The subject line and message body could be hard-coded if needed).

Thanks,

Tyler Geffeney.

Hi..

This is just a basic email script.. you just need to change the cell locations to suit..

You can do other things like making the Subject dynamic, the body can be a range of cells converted to html or the Body message also can be dynamic and include variables from your sheet..

If you want something more specific done.. upload your Workbook and tell us what you want specifically..

btw.. Change the line .Send to .Display if you want each email to send automatically (no preview)..

Please Login or Register  to view this content.

This is great, thank you so much. I did try to copy it over to our excel form and I am getting an error message that says "Run-Time error '1004': SaveAs method of workbook class has failed." Is this because it is saving a new file and if so, can the code just do a save instead of a save as?

I attached the file in case that would help. Also, in order to not have to send multiple emails, I concatenated all the email addresses with a ";" separating them into cell A2 (with a white font). I then also did the same for the subject line into A3, and the message body into A4 thinking that might help.

Thank you once again for all you help. This will truly help our team a great deal.

Weekly Loan Update2.xlsm

Hi..

I added your To and Subject address locations (including the ";") in the code..

I left the message body as A4 (so you can easily change that to suit)..

Probably best to put this file in its own folder as it will create a new excel file for each different doc (customer) you send..