INCLUDETEXT in mail merge doc's?

Posted on 2012-08-11
Medium Priority
Last Modified: 2012-08-16
Hello - I've used INCLUDETEXT in a mail merge situation before, when the included doc's were just straight text, and it worked great.

But now I have a situation where the included doc's have mail merge fields themselves, and they are not getting updated. I did the Control/A, F9 thing, but still no luck.

The main and included doc's are all in the same folder on the network, and all use the same datasource. This is an Access-to-Word mail merge, using Office 2003.

Should this work?

Question by:mlagrange
  • 2
  • 2
LVL 76

Expert Comment

ID: 38285293
I can get it to work in Word 2007. My experiments with 2003 produce 'Error! Not a valid filename', but that system is suspect, so I'll try another.
LVL 76

Accepted Solution

GrahamSkan earned 1500 total points
ID: 38285380
Tried it under 2003 on another system, and it works OK there.

Author Comment

ID: 38285908
Ok, it gets more & more stranger...

I'm using an INCLUDEPICTURE merge field to bring in signature jpg's in the main document. The jpg file names are the employee ID's, that get carried along in the mail merge datasource:
{INCLUDEPICTURE "T://RPA//Sigs//{MERGEFIELD "ConsultantID"}.jpg" \d}

To get them to display correctly in the mail merge result doc, I have to do the Control/A, F9 thing. That (still) works fine.

Here is the yik yak for the INCLUDETEXT:

{INCLUDETEXT "T:\\RPA\\Docs\\Fee Disclosure 2 408a5 {MERGEFIELD "InputText}.doc" \* MERGEFORMAT}

"InputText" is a field in the datasource that indicates which of the 4 versions of the included doc get pulled in by the INCLUDETEXT.

When I first merge the document, everything seems to be working as far as the INCLUDETEXT goes, but when I do the Control/A F9 to get the signature jpg's to update, the mail merge fields in the included doc's display as un-merged ("<< MyMergeField>>")

To make matters worse, the included doc's lose most formatting like justification and tab spacing. I put the doc name in the headers of the invcluded doc's so I can see if I'm pulling in the right version, and that doesn't show either.

Author Comment

ID: 38300484
ok, I wound up abandoning the INCLUDETEXT approach, at least when including doc's with mail merge fields. It's just too flaky.

Thanks for your response, Graham.

Featured Post

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Nice table. Huge mess. Maybe this was something you created way back before you figured out tabs or a document you received from someone else. Either way, using the spacebar to separate the columns resulted in a mess. Trying to convert text to t…
Introduction This tutorial provides instructions on how to properly format your Word document using the inbuilt tools provided. The benefits of using these tools means your documents are more accessible and easily portable to other applications an…
Learn how to make your own table of contents in Microsoft Word using paragraph styles and the automatic table of contents tool. We'll be using the paragraph styles in Word’s Home toolbar to help you create a table of contents. Type out your initial …
In a previous video Micro Tutorial here at Experts Exchange (http://www.experts-exchange.com/videos/1358/How-to-get-a-free-trial-of-Office-365-with-the-Office-2016-desktop-applications.html), I explained how to get a free, one-month trial of Office …
Suggested Courses

839 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question