Exporting all fields from Entourage Contacts for a Word Mail merge

S

Step Parikian

Does anyone know how to access all Entourage's Contact fields in a Word mail
merge? When I bring up the Office Address book in the Data merge manager,
it only shows a limited number of them..


Thanks
 
B

Barry Wainwright

Does anyone know how to access all Entourage's Contact fields in a Word mail
merge? When I bring up the Office Address book in the Data merge manager,
it only shows a limited number of them..
Click to expand...

It can't be done directly through mail merge, but can through applescript
(and word's applescript implementation in 2004 is a massive step forward!).

Take a look at www.scriptbuilders.net for scripts that may accomplish what
you want.
 
P

Paul Berkowitz

Does anyone know how to access all Entourage's Contact fields in a Word mail
merge? When I bring up the Office Address book in the Data merge manager,
it only shows a limited number of them..
Click to expand...

€ Export all the contacts to a tab-delimited text file via
File/Export/Contacts. That will give you every field except Category. (If
you need Category info and/or also do not want carriage returns in Notes to
be replaced by spaces, you'll have to get my "Export-Import Entourage X"
script instead.)

€ In Word, in Data Merge Manager, Create the Document, and in Get Data,
choose Open Data Source (NOT Office Address Book), and navigate to the text
file you exported from Entourage by either method above (built-in or
script).

€ In Merge Field, you'll now find the entire list of Entourage fields
available. (If you've used my script, some of the field names will be a bit
different than what you may be used to). Choose whichever you want, adding
punctuation, spaces and new lines in the sample created in the Word
Document.

€ Merge.

If there's any reason why you think you might want to manipulate the export
file before doing the merge (I can't think of any, but maybe you can), it
will be much easier to import it first into Excel (Data/Get External data)
and do the manipulations there. Then save the Excel file - either as a
standard Excel Workbook or as tab-text. If you want to restore carriage
returns in Notes, use my scripts, including the Excel Export Adapter to do
so, then save as an Excel Workbook.

You can use this data source over and over again, or re-export from
Entourage whenever you need to update it.


--
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