Embedding Word Documents

[egroup]

Here's one for you OLE experts. I currently have a mail merge that I run via automation from Access. It works fine, but is painfully slow making the connection (which I do programmatically). I have read that you can embed Word documents into reports to accomplish mail-merge type tasks, but does it work efficiently? How do I get the fields into the embedded document. By the way, this isn't simply a merge that has Name, Address & Salutation - it also has about a 1/2 dozen merge fields in the body of the document. Is this feasible, or even possible? Will it be any more efficient? Any suggestions or help would be appreciated.

Thanks,
egroup

 

[Carol]

The fastest way to accomplish what you want to do is to create a letter/report outline within Access and merge the fields within the report where they are to be. The one thing that has to be remembered is that each section with embedded text should begin with an =" and end with an " Embedded text within the report should contain the format wanted with the field names. Here is an example of a paragraph in an Access report:
="Thank you in advance, and we look forward to hearing from you and receiving your payment by " & Format(DateAdd("d",10,Now()),"mmmm dd"", ""yyyy") & "."

Good luck