using mail merge to populate a form letter/document

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

lynchjl7748 - 03 Jun 2005 18:43 GMT

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 to this Message

Doug Robbins - 03 Jun 2005 22:35 GMT

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.

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 am trying to use excel to merge into a word document in sveral places and
>I
[quoted text clipped - 12 lines]
> Thanks,
> Jeff

Reply to this Message

Graham Mayor - 04 Jun 2005 04:22 GMT

Enter the field and copy it to the clipboard then use replace to replace
your reference with the clipboard content (^c)

Signature

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

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

> 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
[quoted text clipped - 8 lines]
> Thanks,
> Jeff

Reply to this Message