Merging Access database to Word Document

[SABR]

Once I have the Word document merged with the Access database, I no longer
want the "end product," in this case a letter, linked to the database. But I
do want the merged info to stay. How do I clip the link?

 

[Ken Sheridan]

There is only one way of storing data in a relational database, as values at
column positions in rows in tables. Whatever data generates the merge should
be stored in this way. With the minimal information you've given I can't say
more than this general principle, but would be happy to comment in more
concrete terms if you'd care to post back with more details of how your data
is being used to generate the merge.

Ken Sheridan
Stafford, England

 

[a a r o n . k e m p f]

I think that you need to highlight something called 'display merge
fields' in the Word document.. and to get rid of the merge fields
within the word document. I would tell you more; but I'm on a linux
box

We had to do a ton of (WORD) mail merge using Reporting Services about
a year back.

-Aaron

 

[SABR]

I've created a database with the information I need. I then merge the
information onto a letter in Word. Once the letter is approved, signed and
delivered, I save it to my supervisor's folder. But if she wants to open the
file, she can't because the file is linked to my access information on "My
Documents" and "My Data Sources." Once I have the "end product," how do I
save it so it can be opened without accessing the database? Is that possible?

 

[SABR]

But would the information stay on the letter if I removed the merge fields?

 

[a a r o n . k e m p f]

well yah-- I think that you can _RUN_ a merge and create 2,000
different copies of the document.. and you just want to keep _ONE_ of
those right?

I think that Word supports this-- taking the values in a database;
jamming them (one at a time) into a word doc and then save the word
doc (instead of printing it).

I'll try to look into it later-- but yah; it seems to me like that is
what you want to do-- and it's right out of the box.

I'll look into it this afternoon if I can.

Thanks

-Aaron

 

[Arvin Meyer [MVP]]

I've created a database with the information I need. I then merge the
information onto a letter in Word. Once the letter is approved, signed
and
delivered, I save it to my supervisor's folder. But if she wants to open
the
file, she can't because the file is linked to my access information on "My
Documents" and "My Data Sources." Once I have the "end product," how do I
save it so it can be opened without accessing the database? Is that
possible?

I'd just copy and paste the Word.doc to a new document, and delete the merge
file. If the supervisor just wants a copy, print the first page to a PDF
file.