Home |
Search |
Today's Posts |
#1
|
|||
|
|||
using mail merge to populate a form letter/document
I am trying to use excel to merge into a word document in sveral places and I
was wondering if there was a quick way to set the merge fields. Currenlty I am going through and replaceing the words one by one. I want to be able to insert my merge field like the following Every time the the document says "LTMAX" replace with excel Field LTMAX1... LTMAX would be in mulitple spots on the letter. Any help would be appreciated. Thanks, Jeff |
#2
|
|||
|
|||
In that the mergefields only have to be set up in the document once, using
copy and paste maybe the simplest thing to do. It is however possible to create a macro that will do it. -- 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 "lynchjl7748" wrote in message ... I am trying to use excel to merge into a word document in sveral places and I was wondering if there was a quick way to set the merge fields. Currenlty I am going through and replaceing the words one by one. I want to be able to insert my merge field like the following Every time the the document says "LTMAX" replace with excel Field LTMAX1... LTMAX would be in mulitple spots on the letter. Any help would be appreciated. Thanks, Jeff |
#3
|
|||
|
|||
Enter the field and copy it to the clipboard then use replace to replace
your reference with the clipboard content (^c) -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org lynchjl7748 wrote: I am trying to use excel to merge into a word document in sveral places and I was wondering if there was a quick way to set the merge fields. Currenlty I am going through and replaceing the words one by one. I want to be able to insert my merge field like the following Every time the the document says "LTMAX" replace with excel Field LTMAX1... LTMAX would be in mulitple spots on the letter. Any help would be appreciated. Thanks, Jeff |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Take Mail Merge in Word back the the Mail Merge Helper 1,2,3 Form. | Mailmerge | |||
mail merge with attachments | Mailmerge | |||
any way to use word mail merge with an adobe pdf form | Mailmerge | |||
How can I protect a form and still have mail merge? | Mailmerge | |||
Proteced Form with Mail Merge Section-Mail Merge is "lost" whe | Microsoft Word Help |