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

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.

--
Sue Mosher, Outlook MVP
Author of
Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
http://www.outlookcode.com/jumpstart.aspx


"Gordon" <(E-Mail Removed)> wrote in message news:36DD4F63-A399-40B7-86FA-(E-Mail Removed)...
> 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

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]" wrote:

> 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.
>
> --
> Sue Mosher, Outlook MVP
> Author of
> Microsoft Outlook Programming - Jumpstart for
> Administrators, Power Users, and Developers
> http://www.outlookcode.com/jumpstart.aspx
>
>
> "Gordon" <(E-Mail Removed)> wrote in message news:36DD4F63-A399-40B7-86FA-(E-Mail Removed)...
> > 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
>

See http://support.microsoft.com/default...b;en-us;286431

--
Sue Mosher, Outlook MVP
Author of
Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
http://www.outlookcode.com/jumpstart.aspx


"Gordon" <(E-Mail Removed)> wrote in message news:1D603019-6B99-43D8-AD55-(E-Mail Removed)...
> 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]" wrote:
>
>> 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.

>>
>>
>> "Gordon" <(E-Mail Removed)> wrote in message news:36DD4F63-A399-40B7-86FA-(E-Mail Removed)...
>> > 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
>>

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]" wrote:

> See http://support.microsoft.com/default...b;en-us;286431
>
> --
> Sue Mosher, Outlook MVP
> Author of
> Microsoft Outlook Programming - Jumpstart for
> Administrators, Power Users, and Developers
> http://www.outlookcode.com/jumpstart.aspx
>
>
> "Gordon" <(E-Mail Removed)> wrote in message news:1D603019-6B99-43D8-AD55-(E-Mail Removed)...
> > 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]" wrote:
> >
> >> 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.
>
> >>
> >>
> >> "Gordon" <(E-Mail Removed)> wrote in message news:36DD4F63-A399-40B7-86FA-(E-Mail Removed)...
> >> > 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
> >>
>

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
http://www.outlookcode.com/jumpstart.aspx


"Gordon" <(E-Mail Removed)> wrote in message news:6D0E0057-4B88-49DC-9C84-(E-Mail Removed)...
>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]" wrote:
>
>> See http://support.microsoft.com/default...b;en-us;286431
>>
>>
>> "Gordon" <(E-Mail Removed)> wrote in message news:1D603019-6B99-43D8-AD55-(E-Mail Removed)...
>> > 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]" wrote:
>> >
>> >> 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.
>>
>> >>
>> >>
>> >> "Gordon" <(E-Mail Removed)> wrote in message news:36DD4F63-A399-40B7-86FA-(E-Mail Removed)...
>> >> > 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
>> >>
>>