using mail merge to populate a form letter/document

L

lynchjl7748

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
 
D

Doug Robbins

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
 
G

Graham Mayor

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


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top