|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Search this Thread | Display Modes |
|
#1
January 25th 07, 06:55 PM
posted to microsoft.public.outlook.program_vba
|
|||
|
|||
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? 
|
| Ads |
|
#2
January 25th 07, 07:27 PM
posted to microsoft.public.outlook.program_vba
|
|||
|
|||
|
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?
|
|
#3
January 25th 07, 07:55 PM
posted to microsoft.public.outlook.program_vba
|
|||
|
|||
|
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?
|
|
#4
January 25th 07, 08:14 PM
posted to microsoft.public.outlook.program_vba
|
|||
|
|||
|
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?
|
|
#5
January 25th 07, 08:31 PM
posted to microsoft.public.outlook.program_vba
|
|||
|
|||
|
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?
|
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Import vCard should be able to import multiple contact in one file | pingel | Outlook - Using Contacts | 1 | February 29th 08 02:31 PM |
| Outlook macro abends but Word macro runs successfully | Jreue | Outlook and VBA | 0 | December 13th 06 11:55 PM |
| i want to import list contact from excell,but i can only import | thanhtam | Outlook - Using Contacts | 1 | October 9th 06 01:58 PM |
| Call macro stored in Excel workbook from Outlook's macro | Gvaram | Outlook and VBA | 5 | October 4th 06 06:26 AM |
| Macro to import Excel data to Tasks | Patrix317 | Outlook and VBA | 2 | May 2nd 06 06:32 PM |
Linear Mode
