Thanks a lot for your help.
Let me re-phrase the question (a simpier one). I want to create a Word
template (perhaps using the mail merge), so I can have the mailing address of
a single contact (from Outlook). It happens sometimes to change the mailing
address of the contact in Outlook. The next time I open my Word template I
want to see the new address (derived from Outlook) - Update fields? How can
I do that?
Thanks a lot again.
George
Ο χρήστης "Graham Mayor" έγγραψε:
I don't know a way to do this with mail merge from Outlook. Merges from
Outlook create transient temporary files for the duration. They are not
available for re-use, unless you create a permanent data file which would
not be updated by any changes to the Outlook contact. If youhave to create a
permanent data source then you might as well create an autotext entry in
Word. I have already suggested my take on the best way of doing this. It
merely requires a couple of extra steps from 'automatic'.
You might ask in the vba forum to see if anyone can come up with anything
better.

Signature
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP
My web site www.gmayor.com
Word MVP web site http://word.mvps.org
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
> Thanks a lot for your help.
>
[quoted text clipped - 48 lines]
>>>
>>> George
Your question may be simpler but an answer probably is not (as usual!)
To do this using a MailMerge approach, you could start as follows.
Suppose you make a Word tempalte (or document - I do not think it makes much
difference in this case) that uses your Contact's folder as its Mail Merge
Data Source. Save the template/document, and re-open it, or create a new
document based on the template. At that point you will I think be asked
(twice) to select your contacts folder. That's the real problem here, as we
shall see
Let's suppose you now try to restrict your data source to the one contact
you want to use. You will need to have criteria that uniquely identify the
contact - e.g. Firstname, lastname may or may not be enough.
Open the Mail Merge Recipients dialog box, clcik the drop-down at the top of
one of the columns, and seelct Advanced to view the Query Options dialog.
You can then specify the conditions needed to select that one record. When
you get back into the Mail merge Recipients Dialog box, only one row should
be displayed. Incidentally, you could just "clear" all the entries, and
select the one you want, but then you would be relying on Word's internal,
undocumented mechanism for identifying which records you have selected and I
suspect that is best avoided.
Now close the recipients dialog box. Show the preview data including the
address that you want to see updated. Save the template. Experimentally
change the address data for the contact. When you re-open the Word template,
and select the correct contacts folder, the new data from the contact should
be displayed. However, you have to know which contacts folder to open. If
you get the wrong one, Word won't find the record you wanted.
There is another way you can go about doing this, which is to use Access to
link to a Contacts folder, then use that linked Access table as your data
source. It seems to work quite well to me and avoids some of the problems
mentioned above. At the moment I can only tell you how it works if you have
Access, but a programmatic solution may also be feasible.
Peter Jamieson
> Thanks a lot for your help.
>
[quoted text clipped - 48 lines]
>> >
>> > George
Peter Jamieson - 21 Feb 2007 10:55 GMT
> then use that linked Access table as your data source. It seems to work
> quite well to me
Except you also have to create an Access query that gets all the data from
the Access table then use /that/ as the data source.
> Your question may be simpler but an answer probably is not (as usual!)
>
[quoted text clipped - 93 lines]
>>> >
>>> > George
George - 21 Feb 2007 15:30 GMT
Thanks a lot my friend,
I think I will do it in Access.
Ο χρήστης "Peter Jamieson" έγγραψε:
> > then use that linked Access table as your data source. It seems to work
> > quite well to me
[quoted text clipped - 99 lines]
> >>> >
> >>> > George