Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro To Email Distro List
Thanks that works well!
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using Macro how to create email link for the email addresses in aRange or Selection | Excel Worksheet Functions | |||
Include email dist. list into a Excel macro - how? | Excel Worksheet Functions | |||
Macro to email all drop list selections | Excel Discussion (Misc queries) | |||
How do I create an email macro to auto fill the email? | Excel Discussion (Misc queries) | |||
Email worksheet from a list of names and email | Excel Discussion (Misc queries) |