Export query to Outlook Contacts

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a query contaning the names, addresses & phone #s of the members.
I would like to export the information into Outlook Contacts and have a
seperate detailed vcard for each member.
Can someone please tell me how this can be done?
Thank you.
 
Musician!
I have found an answer which seems to work.
Open your query
From "File" click export.
In the window that opens, at the bottom at
"Save as type" scrolldown to "Microsoft Excel 97-2003" or more recent.
The file name will appear, click "Export All"
This will create an .xls file of your query.

Now Open MS Outlook. Go into your Contacts and click on
and the subfolder you wish to use.
In "File" click Import and Export. In the dialog box that appears
Click Import from another Program or File and next. Another dialog
box will open, click on Microsoft Excel and next. In browse, find
the Excell file you have just created, choose the option you want and click
next.
For your destination folder choose Contacts or the subfolder of Contacts and
Next. Now you get a two pannels window with instructions. Follow
instructions and click OK or next. You may get a last window where you have
to click Finish and your vCards should all be there.
Good Luck
Gemolo
 
Back
Top