Is it possible to merge a directory database from Word to Outlook

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Jeffrey larson - 21 Jun 2006 17:34 GMT

I am doing some organization work as a personal assistant. My employer would
like for me to create an address list that can be printed out for her
Franklin planner. I am using the Word Merge directory option for this. At
some point is there a way to then send this information into Outlook without
having to retype all of the information? That would save me a bunch of
time!!!

Reply to this Message

Doug Robbins - Word MVP - 21 Jun 2006 18:05 GMT

First what you should do is to do an export of the contacts from Outlook to
a Excel file to get the arrangement and field names. Then do an catalog or
directory type mailmerge in Word with the data arranged in the same order,
then execute that merge and copy and paste the result into Excel in place of
the data in the exported file, but leaving the field names in the first row
intact. Then, use the import routine in Outlook to import the data into
the Outlook contacts.

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 doing some organization work as a personal assistant. My employer
>would
[quoted text clipped - 5 lines]
> having to retype all of the information? That would save me a bunch of
> time!!!

Reply to this Message

Jeffrey larson - 23 Jun 2006 19:20 GMT

Doug,
Thank you for the info. Very helpful! However, when I go to import the file
back from Excel, Outlook freezes and closes. I have checked the field
mapping and everything lines up perfectly. I can't imagine what is going on
that would cause this error to occur. Any thoughts??? Also, when setting up
the Word Document, would you recommend trying to force it to look like an
Excel spreadsheet? I was a little fuzzy on what you meant by "arranging in
the same order". You've been a great help. Thanks!!!

> First what you should do is to do an export of the contacts from Outlook to
> a Excel file to get the arrangement and field names. Then do an catalog or
[quoted text clipped - 13 lines]
> > having to retype all of the information? That would save me a bunch of
> > time!!!

Reply to this Message