Hi Chris

If you use Outlook then use
http://www.rondebruin.nl/mail/folder2/mail2.htm

And in the to line use your address
In the BCC line use code that you can find here to use a list in a worksheet
http://www.rondebruin.nl/mail/tips2.htm

If you need more help post back


--
Regards Ron de Bruin
http://www.rondebruin.nl



"Chris Vrionides" wrote in message
...
I need to send the same sheet to a list of people, but in a separate email
for each email address

Thanks



"Ron de Bruin" wrote:

You want to send the same workbook to
all these people
Am I correct


--
Regards Ron de Bruin
http://www.rondebruin.nl



"Chris Vrionides" wrote in message
...
Thanks Bob,
but this website only gives me specific templates (that i don't really want
to risk).

Can anyone help me with the actual code?



"Bob Phillips" wrote:

See www.rondebruin.nl/sendmail.htm

--
HTH

Bob Phillips

"Chris Vrionides" wrote in
message ...
I have a list of email addresses in one workbook and a sheet i want to
attach
and send spearately to all these people in another workbook.

Any ideas on the VBA would be greatly appreciated!