Solved

Inserting fields in Word for Outlook Contact data

Posted on 2006-11-29
9
416 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
Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
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

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Suggested Solutions

Like many others, we try and discourage users from printing documents unnecessarily and instead send or share them electronically. However, this doesn't always work and documents are still printed. With this simple solution, if the user tries to …
Nice table. Huge mess. Maybe this was something you created way back before you figured out tabs or a document you received from someone else. Either way, using the spacebar to separate the columns resulted in a mess. Trying to convert text to t…
This video shows where to find templates, what they are used for, and how to create and save a custom template using Microsoft Word.
This Experts Exchange video Micro Tutorial shows how to tell Microsoft Office that a word is NOT spelled correctly. Microsoft Office has a built-in, main dictionary that is shared by Office apps, including Excel, Outlook, PowerPoint, and Word. When …

828 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