Access > Word - best way to please!

  • Thread starter Thread starter APH
  • Start date Start date
A

APH

Hi

I display a form with contact details in it. What I would like to do is be
able to press a button and merge the details with a pre-defined letter ,
created in Word, and then print it out. What is the best way to achieve
this please?

Alex
 
I would recommend exporting the merge data to a text file and use that as
the data source for the merge, rather than using a linked query as shown in
the sample code in the two articles Van Dinh points to.
You would need to insert merge fields in your pre-defined letter, which can
be done by hand or by setting the data source for the merge, then selecting
them from a list of fields in the data source.
You would need to export the field names as the first record of the file for
the mail merge to work

I can provide some sample code if you are interested

Ragnar
 
Ragnar

That would be very kind of you, and I would be grateful for the sample code.

Thank you so much

Alex
 
Yes, I get a Page Not Found. Did you try yourself? They are correct except
for one character, the Q in fron of the article number is missing.

Ragnar
 
I see, now the links work. I thought it was the missing Q because when I
searched KB with the Q included the articles came up, probably because you
will get hits on anythin containing those digits.

Ragnar
 
Back
Top