macro to generate a word document from an Outlook appointment

D

DavidG

Trying to work out a way of automatically generating a Word document
(letter), when an Outlook appointment is created. An appointment is created
for a client, and we want to automatically generate a letter (or email) to be
sent to the client confirming the appointment.
 
S

Sue Mosher [MVP-Outlook]

The code to create a new Word document from a templat looks like this:

Set wd = CreateObject("Word.Application")
Set myDoc = wd.Documents.Add("C:\your_template.dot", , True)

How -- or more precisely, where -- to code it in Outlook depends on whether you're using a custom form, want to write VBA code, plan to build a COM add-in, etc.
--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003

and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top