Hi Mark,
Ron de Bruin has an extensive range
of sample email code at:
Example Code for sending mail from Excel
http://www.rondebruin.nl/sendmail.htm
---
Regards.
Norman
"NoodNutt" wrote in message
...
Hi all
Is it possible (Using CmdBtn / VB Code) to open microsoft
office outlook and insert recipient(s) e-mail address(s).
Generally I send a workbook via SendTo/As Attachment in the dropdown, then
insert the e-mail addresses, different workbooks are mailed to pre-set
individuals on a daily basis so the code would not have to worry about
variable names/addresses.
TIA
Mark