Open Office Outlook & Insert e-mail address
 

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

Open Office Outlook & Insert e-mail address
 

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

Open Office Outlook & Insert e-mail address
 

Thank you Norman

Will check it out

Regards
Mark

Open Office Outlook & Insert e-mail address
 

Hi Norman

Thx heaps for the pointer, Ron is incredible.

Regards
Mark.