Mailmerge - how to include a linked document?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Stube - 29 Nov 2007 15:42 GMT

I've set up a mailmerge using an Excel spreadsheet as data source. For some
of the addressees, I want to include a separate Word document in the
mailmerged output e.g.
Addressee 1 - Print Standard letter + Doc XYZ
Addressee 2 - Print Standard letter + Doc ABC
etc

I could include a link in the XL file pointing to the separate document, but
how do I tell the mailmerge to open that link and print the Word doc?

Using Word & Excel 2000, by the way.

Reply to this Message

Doug Robbins - Word MVP - 29 Nov 2007 19:17 GMT

In the Excel data source, include a column called (e.g.) Flag and in that
column, enter a 1 for those records for which you want the additional file
included. Then in the mail merge main document, at the location where you
want the file to be appear, insert the following field construction:

{ IF { MERGEFIELD Flag } = 1 { INCLUDETEXT
"DriveLetter:\\Path\\Filename.doc" } "" }

You must use Ctrl+F9 to insert each pair for the field delimiters { } and
Alt + F9 to toggle off their display.

If executing the merge to a new document, you may need to press Ctrl+A to
select everything and then press F9 to update the fields in the document to
get the file to appear.

Signature

Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

> I've set up a mailmerge using an Excel spreadsheet as data source. For
> some
[quoted text clipped - 9 lines]
>
> Using Word & Excel 2000, by the way.

Reply to this Message

Stube - 29 Nov 2007 23:57 GMT

That'll do nicely! Many thanks.

> In the Excel data source, include a column called (e.g.) Flag and in that
> column, enter a 1 for those records for which you want the additional file
[quoted text clipped - 24 lines]
> >
> > Using Word & Excel 2000, by the way.

Reply to this Message