Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Email and if statements
I do not have outlook installed, only outlook express and lotus notes. Is this macro supposed to run automatically on opening th spreadsheet? YOu made this comment "-You can call this sub from your WorkBook_Ope event in the ThisWorkBook module-" so I am wondering if I have to do something t the code you provided in order to make it run automatically. Thanks for your help, it is much appreciated -- sa ----------------------------------------------------------------------- sae's Profile: http://www.excelforum.com/member.php...fo&userid=1538 View this thread: http://www.excelforum.com/showthread.php?threadid=27000 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Email and if statements
Hi
This won't run if you do not have Outlook. I was working on the assumption that you had Microsoft Office. If you don't have Excel, then this code is no good to you at all, and you should be asking your question in a Lotus notes newsgroup. Do you have Excel? If you do, get back to me and we can go through what to do with this code and try and get round the Outlook Express issue. If you do not have Excel, then I can't help. regards Paul sae wrote in message ... I do not have outlook installed, only outlook express and lotus notes. Is this macro supposed to run automatically on opening the spreadsheet? YOu made this comment "-You can call this sub from your WorkBook_Open event in the ThisWorkBook module-" so I am wondering if I have to do something to the code you provided in order to make it run automatically. Thanks for your help, it is much appreciated. |
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 | |||
Transfer Email addresses from spreadsheet to email address book | Excel Discussion (Misc queries) | |||
Email editor closes when forwarding Excel-embedded email | Setting up and Configuration of Excel | |||
Email and if statements | Excel Programming | |||
Email and if statements | Excel Programming |