Macro To Email Distro List
 

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

Macro To Email Distro List
 

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 he

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

"JStone" wrote in message
...
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

Macro To Email Distro List
 

Thanks that works well!