OLE Automation and Word Custom Document Properties (Access XP)

[robyork]

OLE Automation and Word Custom Document Properties (Access XP)

Does anyone know of way to use OLE Automation and Word custom document properties to create a single Word letter based on a template, with data from an address on an Access form and some other fields (ie.. Salutation etc..)

I used to use Access 97 and have the code but when using Access XP I get an error about the msword8.olb not found.

As a quick fix to see if it works I used the file from the office 97 CD and added it to the Office 10 diectory.... As I expected though this didnt work.

Anyones help would be appreciated

RobUK - robuk@ministryofsound.net

 

[scottfarcus]

Go to design of any code module.

Click the Tools menu and select References.

Uncheck reference to Microsoft Word 8.0 Object Library and check the Microsoft Word 10 Object Library reference.

Should fix your problem.

[This message has been edited by scottfarcus (edited 05-23-2002).]

 

[robyork]

Thanks Scott I will try it and post a message to see how it went :->