Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Inserting fields in Word for Outlook Contact data

Posted on 2006-11-29
9
Medium Priority
?
421 Views
Last Modified: 2008-02-01
I see lots of questions re Word and Outlook mail merging but none quite address my issue.

I want to insert Outlook Contact data into Word documents using fields so that if/when the data held in the Contact field changes, so does the Word document (when fields are updated).  (This can be more or less achieved by using the Mail Merge Wizard but it is too cumbersone for one-off letters).  To achieve this you first need to access the Contacts 'database' and I see that Word does this using an SQL query - I know nothing of SQL or JET engines).

Can you tell me how to write a macro to 'open' the Outlook Contacts (these are public contacts held on a MAPI email server) such that I can use the Mail Merge or Database toolbars to insert the fields I want?

This is a tough question but I am sure you are up to the challenge!

Apt-it
0
Comment
Question by:apt-it
  • 4
  • 4
9 Comments
 

Author Comment

by:apt-it
ID: 18037053
I stupidly forgot to tell you that we are using Office XP (2002) - if it helps the email server is Alt-N's MDaemon!
0
 
LVL 22

Expert Comment

by:Dreamboat
ID: 18039628
Can't you instead:

Create a Word template that includes the toolbar button for the Address Book.
http://www.microsoft.com/enable/training/word2002/customtoolbar.aspx

Click the address book button and choose someone to send it to.
0
 

Author Comment

by:apt-it
ID: 18040520
Dreamboat, thanks for you suggestion but the problem is not to get the Outlook contact data into Word but to get a field that points to the Outlook Contact data in.  Using the Address Book only achieves the former.  While this is fine as a quick way to get the address of a contact, for example, it will not enable this data in the Word document to get automatically updated when the contact changes his/her address.
0
New feature and membership benefit!

New feature! Upgrade and increase expert visibility of your issues with Priority Questions.

 
LVL 22

Expert Comment

by:Dreamboat
ID: 18040939
Sorry. You said one-off letters. I saw no reason to want to update a one-off letter address.
0
 

Author Comment

by:apt-it
ID: 18059186
This question has now been resolved by Apt-it so I request that all points be refunded and the quesion closed by the Page Editor.
0
 
LVL 22

Expert Comment

by:Dreamboat
ID: 18059690
If you want your points refunded, please tell us how you resolved it. :)
0
 

Author Comment

by:apt-it
ID: 18059874
This problem was solved, avoiding the need to write a macro, by starting the merge from Outlook.  

If you go the the Contacts folder you want to use (important if it is a Public Contacts folder as in my case) and select one or more recipients, you can then select Mail Merge from the Tools menu which throws you into Word at step 3 of a standard mail merge.

You can then insert the fields you want and complete the merge as normal - plus you can save the Master merge document - relevant even if there is only one recipient, see below.

If the recipient's address changes and his contact details updated in Contacts, then when you open the Master Merge document next time (again, starting from the appropriate Outlook Contacts folder, select the recipient and then browse to the Master merge document) you will find, Hey Presto! that the merge fields have been updated!

All this is designed so that you can set up a template for a client with field codes for this contact details.  The firms master contact table is the public Contacts folder in outlook.  Then if the contact details are updated, the next time you write to him, using the template, you don't need to key or even check his address, phone or other details as these will have been updated automatically!

I think you will agree, Dreamboat, that your suggestion does not contribute to the solution.  Hence my request to have points refinded.
0
 
LVL 22

Expert Comment

by:Dreamboat
ID: 18059881
>>I think you will agree, Dreamboat, that your suggestion does not contribute to the solution.  Hence my request to have points refinded.


No problem. It's just EE policy that if you resolve the issue yourself, we want the answer. :)
Thanks for sharing it!
0
 
LVL 1

Accepted Solution

by:
kodiakbear earned 0 total points
ID: 18060394
Closed, 500 points refunded.
kb
Experts Exchange Moderator
0

Featured Post

Vote for the Most Valuable Expert

It’s time to recognize experts that go above and beyond with helpful solutions and engagement on site. Choose from the top experts in the Hall of Fame or on the right rail of your favorite topic page. Look for the blue “Nominate” button on their profile to vote.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Microsoft Word is a program we have all encountered at some point, but very few of us have dug deep into its full scope of features, let alone customized it to suit our needs. Luckily making the ribbon (aka toolbar, first introduced in Word 2007) wo…
Ever visit a website where you spotted a really cool looking Font, yet couldn't figure out which font family it belonged to, or how to get a copy of it for your own use? This article explains the process of doing exactly that, as well as showing how…
This video teaches the viewer how to align pictures around text while keeping the text properly aligned in the document.
Learn how to make your own table of contents in Microsoft Word using paragraph styles and the automatic table of contents tool. We'll be using the paragraph styles in Word’s Home toolbar to help you create a table of contents. Type out your initial …
Suggested Courses

885 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question