Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Mailmerge field result to insert word document
I have a my data source for mailing customers and once merged the «EntryID»
show ##### which is the customers unique .doc file name. What I need to then get word to do is instead of showing this number is to find the relating .doc file and insert the text from it. Is this possible? |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Mailmerge field result to insert word document
You could use
{INCLUDETEXT "D:\\Path\\{Mergefield EntryID}"} OR {INCLUDETEXT "D:\\Path\\{Mergefield EntryID}.doc"} Depending on what is in the EntryID field -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org "Primus" wrote in message ... I have a my data source for mailing customers and once merged the «EntryID» show ##### which is the customers unique .doc file name. What I need to then get word to do is instead of showing this number is to find the relating .doc file and insert the text from it. Is this possible? |
#3
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Mailmerge field result to insert word document
Hi Graham,
Thanks for the reply, I have tried various versions of what you suggested but just keep getting text after the entry number: 69703{ INCLUDETEXT "Q:\\BookData\\Editor\\Entries{Mergefield EntryID}.doc" } 69703{ INCLUDETEXT "Q:\\BookData\\Editor\\Entries{Mergefield EntryID}" } 69703{ INCLUDETEXT "Q:\BookData\Editor\Entries{Mergefield EntryID}.doc" } 69703{ INCLUDETEXT "Q:\BookData\Editor\Entries{Mergefield EntryID}" } Should I omit anything from the code? "Graham Mayor" wrote: You could use {INCLUDETEXT "D:\\Path\\{Mergefield EntryID}"} OR {INCLUDETEXT "D:\\Path\\{Mergefield EntryID}.doc"} Depending on what is in the EntryID field -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org "Primus" wrote in message ... I have a my data source for mailing customers and once merged the «EntryID» show ##### which is the customers unique .doc file name. What I need to then get word to do is instead of showing this number is to find the relating .doc file and insert the text from it. Is this possible? . |
#4
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Mailmerge field result to insert word document
Press Alt+F9 to toggle off the display of the field codes (and maybe F9 to
update the fields) -- 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, originally posted via msnews.microsoft.com "Primus" wrote in message ... Hi Graham, Thanks for the reply, I have tried various versions of what you suggested but just keep getting text after the entry number: 69703{ INCLUDETEXT "Q:\\BookData\\Editor\\Entries{Mergefield EntryID}.doc" } 69703{ INCLUDETEXT "Q:\\BookData\\Editor\\Entries{Mergefield EntryID}" } 69703{ INCLUDETEXT "Q:\BookData\Editor\Entries{Mergefield EntryID}.doc" } 69703{ INCLUDETEXT "Q:\BookData\Editor\Entries{Mergefield EntryID}" } Should I omit anything from the code? "Graham Mayor" wrote: You could use {INCLUDETEXT "D:\\Path\\{Mergefield EntryID}"} OR {INCLUDETEXT "D:\\Path\\{Mergefield EntryID}.doc"} Depending on what is in the EntryID field -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org "Primus" wrote in message ... I have a my data source for mailing customers and once merged the «EntryID» show ##### which is the customers unique .doc file name. What I need to then get word to do is instead of showing this number is to find the relating .doc file and insert the text from it. Is this possible? . |
#5
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Mailmerge field result to insert word document
Hi Primus,
It appears you've omitted the final path separator from your field code. Before executing the merge it should read: { INCLUDETEXT "Q:\\BookData\\Editor\\Entries\\{Mergefield EntryID}.doc" } -- Cheers macropod [Microsoft MVP - Word] "Primus" wrote in message ... Hi Graham, Thanks for the reply, I have tried various versions of what you suggested but just keep getting text after the entry number: 69703{ INCLUDETEXT "Q:\\BookData\\Editor\\Entries{Mergefield EntryID}.doc" } 69703{ INCLUDETEXT "Q:\\BookData\\Editor\\Entries{Mergefield EntryID}" } 69703{ INCLUDETEXT "Q:\BookData\Editor\Entries{Mergefield EntryID}.doc" } 69703{ INCLUDETEXT "Q:\BookData\Editor\Entries{Mergefield EntryID}" } Should I omit anything from the code? "Graham Mayor" wrote: You could use {INCLUDETEXT "D:\\Path\\{Mergefield EntryID}"} OR {INCLUDETEXT "D:\\Path\\{Mergefield EntryID}.doc"} Depending on what is in the EntryID field -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org "Primus" wrote in message ... I have a my data source for mailing customers and once merged the «EntryID» show ##### which is the customers unique .doc file name. What I need to then get word to do is instead of showing this number is to find the relating .doc file and insert the text from it. Is this possible? . |
#6
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Mailmerge field result to insert word document
Ok if I update the field I still keep getting "Error! Not a valid filename."
I have the word document 69703.doc in the following path "Q:\BookData\Editor\Entries\69703.doc" if I paste this in to windows explorer it opens up the word document so I know it's a valid filename/path. BEFORE MERGE EntryID{ INCLUDETEXT "Q:\\BookData\\Editor\\Entries\\{Mergefield EntryID}.doc" } AFTER MERGE 69703{ INCLUDETEXT "Q:\\BookData\\Editor\\Entries\\{Mergefield EntryID}.doc" } I don't see that I'm missing anything, or should I be putting this code into the EntryID date itself? "macropod" wrote: Hi Primus, It appears you've omitted the final path separator from your field code. Before executing the merge it should read: { INCLUDETEXT "Q:\\BookData\\Editor\\Entries\\{Mergefield EntryID}.doc" } -- Cheers macropod [Microsoft MVP - Word] "Primus" wrote in message ... Hi Graham, Thanks for the reply, I have tried various versions of what you suggested but just keep getting text after the entry number: 69703{ INCLUDETEXT "Q:\\BookData\\Editor\\Entries{Mergefield EntryID}.doc" } 69703{ INCLUDETEXT "Q:\\BookData\\Editor\\Entries{Mergefield EntryID}" } 69703{ INCLUDETEXT "Q:\BookData\Editor\Entries{Mergefield EntryID}.doc" } 69703{ INCLUDETEXT "Q:\BookData\Editor\Entries{Mergefield EntryID}" } Should I omit anything from the code? "Graham Mayor" wrote: You could use {INCLUDETEXT "D:\\Path\\{Mergefield EntryID}"} OR {INCLUDETEXT "D:\\Path\\{Mergefield EntryID}.doc"} Depending on what is in the EntryID field -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org "Primus" wrote in message ... I have a my data source for mailing customers and once merged the «EntryID» show ##### which is the customers unique .doc file name. What I need to then get word to do is instead of showing this number is to find the relating .doc file and insert the text from it. Is this possible? . . |
#7
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Mailmerge field result to insert word document
Hi Primus,
You've got the field code display toggled to 'on'. Press Alt-F9 to toggle it off again. Alternatively (or as well), embed your INCLUDETEXT text field in the mailmerge main document inside a QUOTE field, thus: {QUOTE{ INCLUDETEXT "Q:\\BookData\\Editor\\Entries\\{Mergefield EntryID}.doc" }} That will cause Word to unlink the field and display its output regardless of the field code toggle state when the mailmerge is run. -- Cheers macropod [Microsoft MVP - Word] "Primus" wrote in message ... Ok if I update the field I still keep getting "Error! Not a valid filename." I have the word document 69703.doc in the following path "Q:\BookData\Editor\Entries\69703.doc" if I paste this in to windows explorer it opens up the word document so I know it's a valid filename/path. BEFORE MERGE EntryID{ INCLUDETEXT "Q:\\BookData\\Editor\\Entries\\{Mergefield EntryID}.doc" } AFTER MERGE 69703{ INCLUDETEXT "Q:\\BookData\\Editor\\Entries\\{Mergefield EntryID}.doc" } I don't see that I'm missing anything, or should I be putting this code into the EntryID date itself? "macropod" wrote: Hi Primus, It appears you've omitted the final path separator from your field code. Before executing the merge it should read: { INCLUDETEXT "Q:\\BookData\\Editor\\Entries\\{Mergefield EntryID}.doc" } -- Cheers macropod [Microsoft MVP - Word] "Primus" wrote in message ... Hi Graham, Thanks for the reply, I have tried various versions of what you suggested but just keep getting text after the entry number: 69703{ INCLUDETEXT "Q:\\BookData\\Editor\\Entries{Mergefield EntryID}.doc" } 69703{ INCLUDETEXT "Q:\\BookData\\Editor\\Entries{Mergefield EntryID}" } 69703{ INCLUDETEXT "Q:\BookData\Editor\Entries{Mergefield EntryID}.doc" } 69703{ INCLUDETEXT "Q:\BookData\Editor\Entries{Mergefield EntryID}" } Should I omit anything from the code? "Graham Mayor" wrote: You could use {INCLUDETEXT "D:\\Path\\{Mergefield EntryID}"} OR {INCLUDETEXT "D:\\Path\\{Mergefield EntryID}.doc"} Depending on what is in the EntryID field -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org "Primus" wrote in message ... I have a my data source for mailing customers and once merged the «EntryID» show ##### which is the customers unique .doc file name. What I need to then get word to do is instead of showing this number is to find the relating .doc file and insert the text from it. Is this possible? . . |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formatting a field result in Word | Mailmerge | |||
limiting mailmerge result | Mailmerge | |||
Can you insert a mailmerge field but not print it? | Mailmerge | |||
copy a field result into a footer of a document | Microsoft Word Help | |||
Result in form field to generate comment in next field | Microsoft Word Help |