Automatically login to Outlook and a specific profile on a server?

[Guest]

All,.

I have a need to start up Outlook on a server and make sure it is up and
running and logged in as a specific profile. Ideally this would be done as a
service an automatically restart if it is closed for any reason.

We have a report that is generated in Excel and needs to send itself out
using a macro we wrote. Of course with all the security nowadays, this is
not so easy anymore.

Is there any MVP's out there that might be able to help with this situation?

Thanks in advance.

Gordon Cashmore

 

[Sue Mosher [MVP-Outlook]]

Outlook is not suitable for running on a server or automating as a service. A better solution would be to use CDO for Windows to send the message via a particular SMTP account.

 

[Guest]

Any ideas where I can find examples of doing this from within Excel? The
security of the Macros etc is what causes everything to fail. If we could
get Outlook out of the way, that would be great!!!!

 

[Sue Mosher [MVP-Outlook]]

See http://support.microsoft.com/default.aspx?scid=kb;en-us;286431

--
Sue Mosher, Outlook MVP
Author of
Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers

 

[Guest]

I know we have tried this and works fine, but we are having problems sending
a text file at text in the body of the email, and not as an attachment. Is
there a way to modify this? We have only been able to send the txt file as
an attachment, it seems that sending the text file data in the body of the
email is not possible.

Thanks again for all your help!!!

 

[Sue Mosher [MVP-Outlook]]

You'd need to read the contents of the file (see http://www.outlookcode.com/d/vbscript.htm#fso if you want to use FIleSystemObject methods) and then append that string to the string for the message body. If you want to send an HTML message, you'd need to include proper tagging of HTML elements.

--
Sue Mosher, Outlook MVP
Author of
Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers