Macro to Login in MS Outlook

[bunchukokoy]

Happy New Year!

Administrators,

Sorry for this post, I know it isn't much of a TM1 matter. But I know this is where I can get reliable answers fast. And I really can't find answers to this on the web.

Guys,

Do you know how can I login programmatically using VBA Macro in my Outlook using my username and password?

Here's the thing, my local outlook kinda disconnects in MS Exchange in anytime, so in order to restore the connection I have to type my account. The problem is I have a chore that emails a file but since this outlook requires the user account after it disconnected, the chore will stay up running and would not finish emailing the file.

Does anyone have a solution on this?

Thanks very much!

Bunch

[ParisHilton]

I don't know the whole picture, but can you use a vbscript to connect to exchange and send the email , rather than using outlook?

If you have access to SQL server then you could use that for the email?

P