Open Office Outlook & Insert e-mail address

[NoodNutt]

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

 

[Norman Jones]

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

 

[NoodNutt]

Thank you Norman

Will check it out

Regards
Mark

 

[NoodNutt]

Hi Norman

Thx heaps for the pointer, Ron is incredible.

Regards
Mark.