Missing Fields on right side of e-mail "Match Fields" Office 2007

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

James - 23 Aug 2007 21:44 GMT

When trying to use the "Match Fields" in Word to Create an e-mail, there are
a number of fields from my Excel Data that do not show up on the drop down
menue.
How does one get these fields in Excel to register in the drop down menue?
Thanks

Reply to this Message

James - 24 Aug 2007 14:54 GMT

P.S.
I am using MS Word 2007 & MS Excel 2007

> When trying to use the "Match Fields" in Word to Create an e-mail, there are
> a number of fields from my Excel Data that do not show up on the drop down
> menue.
> How does one get these fields in Excel to register in the drop down menue?
> Thanks

Reply to this Message

Graham Mayor - 24 Aug 2007 15:20 GMT

You appear to be trying to use the AddressBlock tool. Don't! Insert the
fields you want from the Insert Merge Field Button directly into your
document.

You may find http://www.gmayor.com/merge_labels_with_word_2007.htm helpful
(it is not only about labels).

Signature

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

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

> P.S.
> I am using MS Word 2007 & MS Excel 2007
[quoted text clipped - 4 lines]
>> How does one get these fields in Excel to register in the drop down
>> menue? Thanks

Reply to this Message

James - 24 Aug 2007 17:18 GMT

Thanks:
From this URL I was able to solve the problem and linked the Excell sheet
data so that the headings showed up when I used the matched fields
Thanks

> You appear to be trying to use the AddressBlock tool. Don't! Insert the
> fields you want from the Insert Merge Field Button directly into your
[quoted text clipped - 11 lines]
> >> How does one get these fields in Excel to register in the drop down
> >> menue? Thanks

Reply to this Message