Solved

Inserting fields in Word for Outlook Contact data

Posted on 2006-11-29
9
413 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
 
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
How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

 

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

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

It is often necessary in this forum and others to illustrate Word fields as text with the field delimiters replaced with the curly brackets that the delimiters resemble when field codes are being displayed on the document. This means that the text c…
Using Word 2013, I was experiencing some incredible lag when typing.  Here's what worked for me....
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 shows where to find the word count, how to display it, and what it breaks down to in Microsoft Word.

760 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

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now