Nickname in Mail Merge

D

Dan

I am trying to do an mail merge in Word 2004 and when I open the Office
Addressbook as the the data source I cannot f use the nickname field.

Is there anyway to use the nnickname field or do I need to do something
else?
 
P

Paul Berkowitz

I am trying to do an mail merge in Word 2004 and when I open the Office
Addressbook as the the data source I cannot f use the nickname field.

Is there anyway to use the nnickname field or do I need to do something
else?
Click to expand...

As you've noticed, there are a rather limited number of fields available to
Data Merge Manager.

In Entourage, go to File/Export/Local contacts to a list (tab-delimited).

It makes a tab-text .txt file.

In Word/Tools/Data Merge Manager, use this .txt file, rather than Office
Address Book, as your Data Source.

You can now choose any fields, including Nickname, that you wish.

But you can't Query by Category - you have to use the whole set of contacts.
If that's not good for you, first open the .txt file in Excel and remove
contacts you don't want. You still can't sort by category since the Contacts
export does not include a Categories field. But you might find some other
column to sort on. If you need Categories, get my shareware Export-Import
Entourage scripts and export contacts from there. It has a Categories column
and you can sort in that in Excel and delete all rows (contacts) outside
desired categories. The save the worksheet - either Tab-Text (.txt) or Excel
Workbook (.xls) will do. Data Merge Manager in Word can access both types.

--
Paul Berkowitz
MVP MacOffice
Entourage FAQ Page: <http://www.entourage.mvps.org/faq/index.html>
AppleScripts for Entourage: <http://macscripter.net/scriptbuilders/>

Please "Reply To Newsgroup" to reply to this message. Emails will be
ignored.

PLEASE always state which version of Microsoft Office you are using -
**2004**, X or 2001. It's often impossible to answer your questions
otherwise.
 
P

Paul Berkowitz

As you've noticed, there are a rather limited number of fields available to
Data Merge Manager.

In Entourage, go to File/Export/Local contacts to a list (tab-delimited).

It makes a tab-text .txt file.

In Word/Tools/Data Merge Manager, use this .txt file, rather than Office
Address Book, as your Data Source.

You can now choose any fields, including Nickname, that you wish.

But you can't Query by Category - you have to use the whole set of contacts.
If that's not good for you, first open the .txt file in Excel and remove
contacts you don't want. You still can't sort by category since the Contacts
export does not include a Categories field. But you might find some other
column to sort on. If you need Categories, get my shareware Export-Import
Entourage scripts and export contacts from there. It has a Categories column
and you can sort in that in Excel and delete all rows (contacts) outside
desired categories. The save the worksheet - either Tab-Text (.txt) or Excel
Workbook (.xls) will do. Data Merge Manager in Word can access both types.
Click to expand...

Actually, if you do get my Export-Import Entourage scripts, you can export
by Category, or by Selection rather than All Contacts if you wish, so you
wont have to do anything in Excel.

--
Paul Berkowitz
MVP MacOffice
Entourage FAQ Page: <http://www.entourage.mvps.org/faq/index.html>
AppleScripts for Entourage: <http://macscripter.net/scriptbuilders/>

Please "Reply To Newsgroup" to reply to this message. Emails will be
ignored.

PLEASE always state which version of Microsoft Office you are using -
**2004**, X or 2001. It's often impossible to answer your questions
otherwise.
 
Top