Hi Alex,

http://www.rondebruin.nl/mail/add-in.htm

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

wrote in message oups.com...
Help with automated email using excel. NOT SPAM

Hi there i have an expenses report from work and i need to send this
to each mail address in a list
More detail........

Cell A1
A2 A3
Alex radford Your expenses for this week are £10.00



See above this is my format in excel, but i have many lines (range of
around 50 lines) i would like to send an email to each individual
person returning in the body of the email the text in A2. So when i
have compiled my information in the list i can run the macro and it
automatically sends the mail without me having to click send all the
time.

I am quite new to VBA in excel but i am a quick learner and use many
functions etc..

Can anyone help i am prepared to send mail via my works email...
,

Thanks to all
Alex