Macro to import from Access

  • Thread starter Thread starter John Hipskind
  • Start date Start date
J

John Hipskind

I would like to develop a macro to import an email list
from Access; essentially, to automate the steps required
by Outlook's Import and Export Wizard. I'm hoping there's
a standard macro for this, so there is little or no user
intervention in the process.

One of my concerns is how to "pre-map" the Access fields
to Outlook without using the Wizard--for example, if my
Access EMAIL table has 4 fields: FirstName, LastName,
EmailAddress and EmailDisplayName.

Thanks for your help.

John
 
John

I set up automatic import by first of all creating an import specification - you do this one time only by using the wizard and then saving the information in the wizard. When you run the inport macro, you use the name of the import specification in the call and it takes care of everything for you

Cheers

Nick
 
-----Original Message-----
John

I set up automatic import by first of all creating an
Click to expand...
import specification - you do this one time only by using
the wizard and then saving the information in the wizard.
When you run the inport macro, you use the name of the
import specification in the call and it takes care of
everything for you
Cheers

Nick
.
Click to expand...
Nick:
I'm lost.
How do I save the original information in the wizard? I
don't see any option to do this.
Does saving the information create the macro? If not, how
is the macro created? Or is the macro created from
scratch in VB? I'm not that familiar with VB code.
Thanks again.
John
 
Back
Top