INCLUDETEXT in mail merge doc's?

Posted on 2012-08-11
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
    LVL 76

    Expert Comment

    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

    Tried it under 2003 on another system, and it works OK there.

    Author Comment

    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

    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.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How to improve team productivity

    Quip adds documents, spreadsheets, and tasklists to your Slack experience
    - Elevate ideas to Quip docs
    - Share Quip docs in Slack
    - Get notified of changes to your docs
    - Available on iOS/Android/Desktop/Web
    - Online/Offline

    I would like to show you some basics you can do with Mailings in MS Word. It´s quite handy feature you can use for creating envelopes, labels, personalized letters etc. First question could be what is this feature good for? Mailing can really he…
    This is written from a 'VBA for MS Word' perspective, but I am sure it applies to most other MS Office components where VBA is used.  One thing that really bugs me is slow code, ESPECIALLY when it's mine!  In programming there are so many ways to…
    This video walks the viewer through the process of creating Hyperlinks for the web and other documents. Select the "Insert" tab: Click "Hyperlink":  Type "http://" followed by a web address to reference a website or navigate to a document to ref…
    In a previous video Micro Tutorial here at Experts Exchange (, I explained how to get a free, one-month trial of Office …

    737 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

    Need Help in Real-Time?

    Connect with top rated Experts

    18 Experts available now in Live!

    Get 1:1 Help Now