Select MS Outlook Theme from Access VBA

[NeilIrving]

I build MS Access databases for small businesses. Generating emails from within Access is no problem - I can even use Access VBA to select specific email accounts and email signatures. However, I have not been able to find a way to use Access VBA to select a Theme that was set up in Outlook. If I create a Theme using the Outlook 2010 menu selections: Options / Mail / Stationery and Fonts / Theme, that theme is present every time I generate a new email from within Outlook. But if I generate a new email via Access VBA, that theme is no longer present - the email that VBA generates has no Theme. What Access VBA code do I need to use to select an Outlook Theme - even just the default Outlook Theme?

One thought is that if someone knows the keyboard shortcuts to select an Outlook Theme, I can do the rest. I can use SendKeys. But if there is a more sophisticated way of making the Theme appear on emails generated by Access VBA, I am eager to learn.

I am using Access 2010, by the way.

 

[spikepl]

Cross posted :

http://windowssecrets.com/forums/showthread.php/159355-Select-MS-Outlook-Theme-from-Access-VBA

Please don't cross-post without providing links to your cross-posts. We answer questions for free. Please don't waste the time of the people helping you.
For cross-posting etiquette, please read: http://www.excelguru.ca/content.php?184

 

[NeilIrving]

My apologies for not following the correct protocol with regard to cross-posting. I figured that the two forms were totally separate with separate experts monitoring them. I was so keen to get an answer that I found two different forums to post my question on. I'll follow your recommended process now.