Creating Outlook Appointments in Word using Access

[Guy]

Hi All,

As a newbie to Outlook VBA programming and following on from an earlier
posting...

How do I populate the body of an appointment with an existing word document
that I have populated using automation?

The .MailEnvelope method does not appear to be supported for appointments.

I understand that I can get Word object from the inspector but this does
support the .Open file method, and if I can help it I don't want to create
the document from scratch.

I tried a .Content.Copy from standard Word with the idea that I could do a
..Content.Paste with the inspector Word object but again this does not appear
to be supported.

I am sure I missing something obvious. Can you help?

Guy

 

[Sue Mosher [MVP-Outlook]]

Maybe what you're missing is that Word is the editor for appointment bodies only in Outlook 2007. In other words, there is no Word.Document object available from an appointment Inspector in earlier versions, nor is there any native method for working with the formatted appointment item body.

Maybe the solution is to set the value of AppointmentItem.Body directly rather than automate Word in between. If you need a formatted appointment body, your options are limited to Redemption or CDO 1.21, plus a helper .dll. See http://www.outlookcode.com/article.aspx?id=31

 

[Guy]

Please ignore my findings above as they are incorrect.

Have managed to get it working using a copy and paste approach.

However, if there is an easier method please advise

Guy

 

[Guy]

Hi Sue,

I am using Office 2007 (thankfully) and I have managed to get it working by
using automation from MS Access to MS Word to populate the document, copying
the document to the clipboard, then opening the appointment inspector word
object and pasting.

I have to admit it does seem a somewhat "clutzy" approach, and welcome any
refinements from more exprienced Outlook VBA'ers

Regards,
Guy