Tuesday, July 29, 2014

How To Importing or Linking Data from a Mail Program in Access 2003

If you have data in a mail program, such as Microsoft Exchange or Microsoft Outlook, you can use the Import From Exchange/Outlook Wizard or the Link To Exchange/Outlook Wizard to import or link your Contacts folder. You can use the information from your Contacts folder to create form letters and mailing labels by merging the data using the Microsoft Word Mail Merge Wizard. You need to have Microsoft Outlook, Outlook Express, or Microsoft Exchange installed on your computer to use these wizards to import or link data.

Import or Link Data from Microsoft Exchange or Outlook

graphics/1_icon.jpg
Open the database in which you want to import or link data.
graphics/2_icon.jpg
Click the File menu, point to Get External Data, and then click Import or Link Tables.
graphics/3_icon.jpg Click the Files Of Type list arrow, and then click Outlook or Exchange.
The Import or Link Exchange/ Outlook Wizard dialog box opens.
graphics/4_icon.jpg
Click the Contacts folder icon (use the plus and minus signs to display folders), and then click Next.
graphics/5_icon.jpg
Follow the remaining wizard instructions; some of the requested information includes:
  • A worksheet or named range
  • First row column heading
  • A new or existing table
  • Field information
  • Primary key
  • Table name
graphics/6_icon.jpg
When you're done, click Finish.
graphics/11inf06.jpg