Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Word / Programming / December 2004

Tip: Looking for answers? Try searching our database.

Pulling Outlook contacts into word

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
kurt - 11 Dec 2004 15:08 GMT
I have created a letterhead user form which gives the user
a choice of filling in an address for the resulting letter
template, or clicking a button which should allow him to
pull a contact from his/her Outlook contact folder.  My
code in the Letterhead user form is this (the name of the
button on the userform to access Outlook contacts is
boxOutlook):

If ofrmletterhead.boxOutlook = True Then
   Selection.HomeKey Unit:=wdStory
   Selection.MoveDown Unit:=wdLine, Count:=1
   WordBasic.InsertAddress

The WordBasic.InsertAddress feature does take me into the
Outlook window where I can select the Contacts folder,
then the appropriate contact.  HOWEVER, the result of this
command DOES NOT bring into the Letter template the
information from the Contact COMPANY field, and it brings
in "The United States of America."

I am looking for help to CUSTOMIZE what the
WordBasic.InsertAddress command does.  The VBA needs to
select the CORRECT FIELDS from the Outlook Contact form,
ie. the Company Name field, and omit others, i.e. the
Country field.

CAN ANYONE PLEASE HELP? I am very unsure as to how and
what the code should be in my Letterhead userform.

THANKS SO MUCH!!!
Kurt
Doug Robbins - 11 Dec 2004 21:32 GMT
See http://www.slipstick.com/contacts/insword.htm

Signature

Please respond to the Newsgroup for the benefit of others who may be
interested.   Questions sent directly to me will only be answered on a paid
consulting basis.

Hope this helps,
Doug Robbins - Word MVP

>I have created a letterhead user form which gives the user
> a choice of filling in an address for the resulting letter
[quoted text clipped - 27 lines]
> THANKS SO MUCH!!!
> Kurt

Rate this thread:






 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.