Macro to Import

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

Guest

I am experienced in coding for Access, but this is my first venture into
coding for Outlook. Currently, I manually import an Access table into a
Contacts Subfolder called "Cities", then run an e-mail merge document called
"MergeDoc.doc". Is there any way to code a macro to do this?
 
Yes, it's possible, but it wouldn't be Outlook coding. You'd write either an Access macro to automate Word's mail merge functionality or a Word macro to perform the merge.

--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003

and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
 
Hmmm. I normally do all of this in Outlook. From Outlook I go to
File>Import and follow the wizard, then I switch over to contacts and go to
Tools>Mail Merge to do the e-mail. Is the code similar throughout Microsoft
applications? I know in Access the code would read something like:

docmd.import "TblOutlook"
docmd.mergedata "MergeDoc.doc"

but again, I'm clueless in Outlook.
 
You're adding an extra, unnecessary step. A mail merge can use an Access database as its data source. Try it!

--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003

and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
 
Interesting, I just double-clicked on my MailMerge.doc document and it opened
up with the correct data (I had evidently already linked it during my
previous process). I can probably just have a button in Access that
hyperlinks to open the MailMerge.doc document and I've just cut 15 minutes
out of my day.

Thanks.
 
Back
Top