Email from Excel Spreadsheet data

[SJG504]

Hi everyone,

I have a list of client's email addresses in a spreadsheet that I would like to send out an email to once a month. I would prefer to use a macro via a command button for this purpose to simplify the procedure for users other than myself.

Example:
Sheet Name: Client Data
Column E: Email Address

Not sure how much more info you need to assist, don't hesitate to ask as I appreciate the assistance.

 

[Dazzawm]

Ron may be able to help!

http://www.rondebruin.nl/sendmail.htm

 

[SJG504]

Thank you very much it worked a real treat, greatly appreciated.