Macro To Email Distro List

[JStone]

Trying to create a macro to email Excel file but when
recording the macro in Excel with Microsoft Outlook it
get's stuck when you tell it who to address the email to.
It simply does not record what you are typing in. (File\
Send To...) Anyone program a macro to do this before?
Thanks, JStone

 

[Tom Ogilvy]

Are you using the sendmail command. If so, it is only one command - you
should be able to see the arguments in the help file. If you are doing
something more complex, perhaps you can get useful examples here:

Dick Kusleika's site

http://www.dicks-clicks.com/excel/olSending.htm

Ron de Buin's site

http://www.rondebruin.nl/sendmail.htm

Regards,
Tom Ogilvy

 

[John Baker]

Thanks that works well!