Macro to Import

[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?

 

[Sue Mosher [MVP-Outlook]]

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

 

[Guest]

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.

 

[Sue Mosher [MVP-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

 

[Guest]

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.