openning a Mail Merged .doc

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have an Access form that takes an entered Employee name and runs queryA and
a append queryB. (The record in the table that queryB is appended to is
always deleted prior to query run). Once this is accomplished the procedure
exports and opens a report that queryA is linked to as RTF (.doc) thereafter
opens a second existing mail merge Word document that is already linked to
the queryB append table. My problem is that when I open the mail merged
document through the Access VBA procedure it does not reflect the new record
in the queryB appended table but when I open the same document manually first
it prompts me that it will run a SQL statement to merge that data and when I
click OK it shows the new record. (keep in mind that when the same mail merge
document is opened through the VBA procedure it does not prompt me for
anything instead opens the document with old record)

BACKGROUND
The reason I am using this mail merge approach is due to the formatting of
the document which CAN NOT be exported through an Access Report and
ultimately this Word document is subject to manual change prior to
finalization/filling.

Any help on the current process or alternate suggestions would be greatly
appreciated.
Thank you in advance.
A.S.
 
Thank you for the response. I reviewed your code and I'm not sure if it
would apply to my scenario since I already have a Word document designed for
the fields to be merged. Through your gui it asks to create a new doc from
scratch, if I'm not mistaking...
 
Back
Top