Outlook apptmt details into Word letter

K

Kerry Voelker

I work for an accounting firm and we send out hundreds of appointment letters to all of our clients for their tax appointments with us. These appointments are all in the Outlook calendar (this is the first year we will be using Outlook for our calendaring). Is there a way to create the appointment letter in Word and have it "pull in" the appropriate data into the appropriate places into the letter? Example:

Dear (use name from appointment in Outlook calendar),

Your appointment is on (date from appointment in Outlook) at (time of appointment from Outlook).....

Thank you,

Kerry
 
S

Sue Mosher [MVP]

Yes, it can be done using VBA code to push data into a Word document, preferably one based on a template with form fields at book marks. See http://www.slipstick.com/dev/customprint.htm
--
Sue Mosher, Outlook MVP
Outlook and Exchange solutions at http://www.slipstick.com
Author of
Microsoft Outlook Programming: Jumpstart
for Administrators, Power Users, and Developers



I work for an accounting firm and we send out hundreds of appointment letters to all of our clients for their tax appointments with us. These appointments are all in the Outlook calendar (this is the first year we will be using Outlook for our calendaring). Is there a way to create the appointment letter in Word and have it "pull in" the appropriate data into the appropriate places into the letter? Example:

Dear (use name from appointment in Outlook calendar),

Your appointment is on (date from appointment in Outlook) at (time of appointment from Outlook).....

Thank you,

Kerry
 

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