Email and if statements

  • Thread starter Thread starter sae
  • Start date Start date
S

sae

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
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Add-In to catch application events 1
Email and if statements 1
Error Trapping 3
Email and if statements 1
Macro for special Insert comment text 16
IF statements in Macros 4
Sending each spreadsheet via email to a different person 2
If statement works here, case doesn't 1

Back
Top