I can't remember of the top of my head if there are any issues with macros
not running if Outlook is automated from an external application. I'll
check, but first - why exactly do you need to run Outlook from Excel?

--
Eric Legault (Outlook MVP, MCDBA, MCTS: Messaging & Collaboration)
Try Picture Attachments Wizard for Outlook:
http://www.collaborativeinnovations.ca
Blog: http://blogs.officezealot.com/legault/


"AM" wrote:

Thanks for you reply. I should have mentioned it earlier, I already put the
excel logic in to Application.Reminder event in ThisOutlookSession. The
problem comes up when i am opening outlook from excel. The event does not
fire when outlook is opened from excel. Should I be declaring Outlook object
in excel with the with events key word? I am not declaring any events in
excel.

Thanks!!

"Eric Legault [MVP - Outlook]" wrote:

The Reminder event is most likely not firing in your Excel macro because you
haven't declared an Outlook.Application object using the With Events keyword,
which allows access to the Application.Reminder event. This event is
automatically wired up for you in the ThisOutlookSession module in the
Outlook VBA Editor, so you should probably move your reminder and Excel
handling code there.

--
Eric Legault (Outlook MVP, MCDBA, MCTS: Messaging & Collaboration)
Try Picture Attachments Wizard for Outlook:
http://www.collaborativeinnovations.ca
Blog: http://blogs.officezealot.com/legault/


"AM" wrote:

I am trying to open outlook from excel with Inbox as the default folder and
use the Task to fire a reminder. In the remainder event of outlook I am
opening an excel sheet selecting some cells and sending out an email.
I am not sure if this is the best way to do it, but since I have to install
it on a corporate server, it has to fire up and send email every day I found
out that this way works with out having to install anything new.
Now, the problem is the code inside the remainder event in outlook fires and
works if the outlook is opened manually. If the outlook is opened by excel
this event does not fire.
Please advice on what might be a cause and if this is the best way of doing
what I explained above.
Thanks.