Sending an email with Access problem,

[MyNeckHurts]

I have an issue sending an email in Access. The code is running on a server as a schedueld task. It all works fine until the code try opens Outlook 2002. At that point a message box appears that asks for the outlook profile ("choose profile"). It defaults to the company profile and when I click yes everything finishes as designed. My issue is that this module needs to run independently with no human intervention. Is there a way to bypass this issue?

PS I have solved the security issue with an application called clickyes but still have the choose profile issue.

 

[VBAjedi]

I haven't seen code that does quite what you are asking, but what about simply putting a shortcut to Outlook into the startup folder so it is always running?

VBAjedi

 

[PHV]

You may also consider launching outlook with the /profile "profile name" command line switch.


Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244