Using Outlook From Within Access

[Guest]

Hello,

My question is: Can you programatically set the Profile Name and Default
Profile for Outlook from within Access code?

The reason for asking:
I have more than a few automated processes that use different automated
Access applications to send files using Outlook from within the Access code.
It turns out that since Outlook will ask for a PROFILE NAME and also ask if
it should be SET AS DEFAULT PROFILE. Once these questions are answered once,
then the next time the procedure goes off it doesn't ask again.

This functionality is needed and since the newest Access service pack
doesn't allow quite this functionality, the automation computer has a lower
service pack installed. Although the process seems neat there are times when
adjustments to the application are made and the unautomated questions will
have to be answered. Also, it would be nice to be able to use the newest
service pack.

Thank you,
Michele

 

[John Nurick]

Hi Michele,

If you can do in VBA code running under Outlook you can almost certainly
do it from VBA running under Access. I don't know whether it can be done
in Outlook, but I'd start by looking at www.outlookcode.com and
www.slipstick.com.