View Single Post
  #3  
Old June 17th 08, 05:54 AM posted to microsoft.public.outlook.program_vba
guy
external usenet poster
 
Posts: 33
Default Creating Outlook Appointments in Word using Access

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

"Sue Mosher [MVP-Outlook]" wrote:

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
--
Sue Mosher, Outlook MVP
Author of Microsoft Outlook 2007 Programming:
Jumpstart for Power Users and Administrators
http://www.outlookcode.com/article.aspx?id=54


"Guy" wrote in message ...
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


Ads