Solved

Inserting fields in Word for Outlook Contact data

Posted on 2006-11-29
9
415 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
Courses: Start Training Online With Pros, Today

Brush up on the basics or master the advanced techniques required to earn essential industry certifications, with Courses. Enroll in a course and start learning today. Training topics range from Android App Dev to the Xen Virtualization Platform.

 
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

Live: Real-Time Solutions, Start Here

Receive instant 1:1 support from technology experts, using our real-time conversation and whiteboard interface. Your first 5 minutes are always free.

Question has a verified solution.

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

When creating Microsoft Word-based forms there may be a need to have a form field repeated throughout the whole document. For instance, with a company name, you may want this information repeated automatically throughout the document rather than man…
A few years ago I was very much a beginner at VBA, and that very much remains the case today.  I'll do my best to explain things as I go in the hope that other beginners can follow.  If you just want to check out a tool that creates a Select Case fu…
This video walks the viewer through the process of creating a watermark for their document, customizing it, and saving it for viewing/printing needs.
This video walks the viewer through the process of creating Hyperlinks for the web and other documents. Select the "Insert" tab: Click "Hyperlink":  Type "http://" followed by a web address to reference a website or navigate to a document to ref…

776 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