|
|
Macro to Import
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? |
Macro to Import
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 http://www.turtleflock.com/olconfig/index.htm and Microsoft Outlook Programming - Jumpstart for Administrators, Power Users, and Developers http://www.outlookcode.com/jumpstart.aspx "Todd K." wrote in message ... 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? |
Macro to Import
Hmmm. I normally do all of this in Outlook. From Outlook I go to
FileImport and follow the wizard, then I switch over to contacts and go to ToolsMail 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]" wrote: 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 http://www.turtleflock.com/olconfig/index.htm and Microsoft Outlook Programming - Jumpstart for Administrators, Power Users, and Developers http://www.outlookcode.com/jumpstart.aspx "Todd K." wrote in message ... 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? |
Macro to Import
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 http://www.turtleflock.com/olconfig/index.htm and Microsoft Outlook Programming - Jumpstart for Administrators, Power Users, and Developers http://www.outlookcode.com/jumpstart.aspx "Todd K." wrote in message ... Hmmm. I normally do all of this in Outlook. From Outlook I go to FileImport and follow the wizard, then I switch over to contacts and go to ToolsMail 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]" wrote: 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. "Todd K." wrote in message ... 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? |
Macro to Import
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. "Sue Mosher [MVP-Outlook]" wrote: 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 http://www.turtleflock.com/olconfig/index.htm and Microsoft Outlook Programming - Jumpstart for Administrators, Power Users, and Developers http://www.outlookcode.com/jumpstart.aspx "Todd K." wrote in message ... Hmmm. I normally do all of this in Outlook. From Outlook I go to FileImport and follow the wizard, then I switch over to contacts and go to ToolsMail 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]" wrote: 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. "Todd K." wrote in message ... 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? |
| All times are GMT +1. The time now is 03:37 PM. |
Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Search Engine Friendly URLs by vBSEO 2.4.0
Copyright ©2004-2006 OutlookBanter.com