linking documents together and mail merging at the same time

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

carrol - 27 May 2005 03:15 GMT

I want to be able to link about 5 different documents together and merge them
with my access table.

Can this be done?

Thank you!

Reply to this Message

Graham Mayor - 27 May 2005 04:31 GMT

We will need a better description of what you are trying to achieve in order
to say whether this is possible.

Signature

<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

> I want to be able to link about 5 different documents together and
> merge them with my access table.
>
> Can this be done?
>
> Thank you!

Reply to this Message

carrol - 29 May 2005 18:09 GMT

I have five documents with merge codes. I have the data in access. If I
merge each document with my data it's fine. However, I want to be able to
run the mailmerge for the five documents at one time with the access data.
So, I thought if I could like the docs together, I could merge all the docs
at one time rather than merging each document separately. I don't want to
have to insert each file in the main file and merge it, I want each document
in it's own file.

> We will need a better description of what you are trying to achieve in order
> to say whether this is possible.
[quoted text clipped - 5 lines]
> >
> > Thank you!

Reply to this Message

Graham Mayor - 30 May 2005 05:00 GMT

Create a new document containing includetext fields referencing the
individual documents.
eg
{INCLUDETEXT "D:\\path\\docname1.doc"}
{INCLUDETEXT "D:\\path\\docname2.doc"}
{INCLUDETEXT "D:\\path\\docname3.doc"}
{INCLUDETEXT "D:\\path\\docname4.doc"}
{INCLUDETEXT "D:\\path\\docname5.doc"}

The original documents may have to be unlinked from the data source (set
each to normal word document from the merge toolbar -
http://www.gmayor.com/mail_merge_labels_with_word_xp.htm ) and you will
probably need to insert a manual page break between each includetext field,
to separate the documents in the final merge. Attach the data file to this
new document, select all (CTRL+A) and update the fields (F9) and you will
have a new document which links all the other documents together, which you
should be able to merge normally. Provided you update the fields in this new
document before you run the merge, and changes in the original documents
will be reflected in the merge document.

Signature

<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

> I have five documents with merge codes. I have the data in access.
> If I merge each document with my data it's fine. However, I want to
[quoted text clipped - 21 lines]
>>>
>>> Thank you!

Reply to this Message

carrol - 11 Jun 2005 17:03 GMT

ok. this works well.

Now I have a problem. I have access set up so that I enter data on a table
and then merge it to my word document. However, When I merge the document, I
want to be able to pick the clients I want the merge for - I don't want it to
merge all of the records (clients) I enter. So the way it is now, I might
have 50 clients I enter data for but only one that I want to use at this time
to merge.

Any ideas?

Thanks!

> Create a new document containing includetext fields referencing the
> individual documents.
[quoted text clipped - 41 lines]
> >>>
> >>> Thank you!

Reply to this Message

cth5c - 15 Jun 2005 16:33 GMT

I have a similar situation, and tried your solution. Five similar documents,
using the same data source, each letter filtering the data with SKIPIF
statements based one one of the fields. I made sure the data source (in my
case, an Excel file) was unlinked from the merge documents before I linked
them together with an INCLUDETEXT statement.

When I went to update the fields, I got the message that some or all the
fields could not be updated. Then, when I merged, I got errors, and ended up
with the first original document merged, with four INCLUDETEXT statements at
the end of each letter. What am I doing wrong?

C. Baber

> Create a new document containing includetext fields referencing the
> individual documents.
[quoted text clipped - 41 lines]
> >>>
> >>> Thank you!

Reply to this Message