Save merged template as document

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Greg - 07 Jul 2004 16:16 GMT

I have a template that merges new data from Access based
on a query. The query returns multiple records that can
be viewed in the template as individual documents. I can
then save that document as a "snapshot" of the queried
data.

My problem is that when I open a document saved in this
way, if there are any records in the query it uses that
data instead of the data at the time of the save. So if I
save a record as a document, then two weeks later want to
look at it, it shows me the current data instead of the
saved data. If there is no current data in the query,
then the document has the correct data (the data at the
time of the save). Is there anything I cna do about this?

Reply to this Message

Peter Jamieson - 07 Jul 2004 19:47 GMT

Before you save, use ctrl-A to select all the document text and use
ctrl-shift-F9 to "unlink" all the fields (i.e. replace the fields by
their results. If necessary, do the same for any heders and footers - if
you need to do /that/ a lot, consider using a macro that unlinks the
fields in each different "story" in a document.

The downside is that you'll probably need to re-open your mail merge
main document when you want to process another record.

Peter Jamieson

> I have a template that merges new data from Access based
> on a query. The query returns multiple records that can
[quoted text clipped - 10 lines]
> then the document has the correct data (the data at the
> time of the save). Is there anything I cna do about this?

Reply to this Message