PDA

View Full Version : VBA Code to open stationery



ronza
03-17-2012, 05:35 AM
Hi Everyone,
I'm a newbie to vba so please pardon my ignorance!

I've created a new custom stationery in Outlook 2007. The new stationery contains a table which users have to fill in and email to clients and colleagues.

I need a macro/code that I can connect to a button that would put the new custom stationery in the body of an already open email, when it is needed and just use outlook as normal most of the time.

I tried a piece of code from Eric's blog found here:
blogs.officezealot.com/legault/archive/2005/07/21/7581.aspx

It actually creates a form that lets you choose which stationery you want and works great on the existing stationery but gives an error, image file not found when I try to open my new custom one, however; the new custom one works great when it is set through outlooks, tools > option path.

Can anyone shed any light on this because I am just starting out and been asked to do this by my boss:banghead: so all help greatly appreciated.

Thanks a mill,

Ronza.