Merge data file location drops out of template when edited

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Dixie - 26 Jun 2006 02:10 GMT

I have a series of templates that are mailmerge main documents. Each one
has the path to the text file with the merge data set in it, just by using
the mailmerge helper.

Sometimes, when users edit these templates, the template loses the path to
the data file. Does anyone else have this happen and if so, is there an
easy fix other than using the mailmerge helper again and reattaching the
source file?

Reply to this Message

Graham Mayor - 26 Jun 2006 13:09 GMT

It shouldn't lose the path if the data file is in the same folder as the
document or is in the My Data Sources Folder.
Yoi can always re-attach from the merge toolbar.

Signature

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

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

> I have a series of templates that are mailmerge main documents. Each
> one has the path to the text file with the merge data set in it, just
[quoted text clipped - 4 lines]
> is there an easy fix other than using the mailmerge helper again and
> reattaching the source file?

Reply to this Message

Dixie - 26 Jun 2006 22:01 GMT

I have never heard of the My Data Sources folder. I use Windows XP SP2.
Where is it located?

> It shouldn't lose the path if the data file is in the same folder as the
> document or is in the My Data Sources Folder.
[quoted text clipped - 8 lines]
>> is there an easy fix other than using the mailmerge helper again and
>> reattaching the source file?

Reply to this Message

Doug Robbins - Word MVP - 27 Jun 2006 04:32 GMT

Under My Documents. The full path will be C:\Documents and Settings\[user
name]\My Documents\My Data Sources

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 have never heard of the My Data Sources folder. I use Windows XP SP2.
>Where is it located?
[quoted text clipped - 11 lines]
>>> is there an easy fix other than using the mailmerge helper again and
>>> reattaching the source file?

Reply to this Message

Dixie - 27 Jun 2006 05:30 GMT

With the [User name] part of that path, can you use some sort of variable
that would pick it up from a network logon?

dixie

> Under My Documents. The full path will be C:\Documents and Settings\[user
> name]\My Documents\My Data Sources
[quoted text clipped - 14 lines]
>>>> is there an easy fix other than using the mailmerge helper again and
>>>> reattaching the source file?

Reply to this Message

Doug Robbins - Word MVP - 27 Jun 2006 12:27 GMT

See the article "How to get the username of the current user" at:

http://www.word.mvps.org/FAQs/MacrosVBA/GetCurUserName.htm

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

> With the [User name] part of that path, can you use some sort of variable
> that would pick it up from a network logon?
[quoted text clipped - 19 lines]
>>>>> is there an easy fix other than using the mailmerge helper again and
>>>>> reattaching the source file?

Reply to this Message