Home |
Search |
Today's Posts |
#1
|
|||
|
|||
mail merge Outlook2000 to Word97 by VBA
Co-worker running Word97 mailmerges from his Outlook2000 contact folder
several times a week/month so would like to automate the process. Sounds simple, but Outlook lacks the macro recorder so need help with the underlying vba; especially since whomever loaded Outlook omitted installing Outlook's vba help file. Havent had much luck with Google/Usenet on this yet, encountering numerous reccomendations to start the merge from Outlook...however the few postings found regarding automating this process imply it cant be done....although there are plenty of examples confirming there ARE contact list properties/methods so it should be possible?? One vba example from (misplaced url) indicates it does this, however imports the selected Outlook97 contacts into an Access97 table then mailmerges from it. Unfortunately we dont have Access. The manual screens imply its essentially: With selected Contacts mail merge using only selected contacts to existing document (say c:\desktop\sales letter form.doc) merge option: form letter merge to new document end with so presumably we could resort to a WSH Sendkeys routine but shouldnt this be possible for a VBA routine WITHIN either Outlook or Word ?? |
#2
|
|||
|
|||
If your co-worker is already using Outlook Tools|Mail Merge to initiate the
merge, I think the basic problem is that Outlook VBA does not have the methods to replicate that particular process programmatically. In fact there are quite a lot of things you can do manually in Outlook that do not have corresponding methods in Outlook VBA - for example, I have a feeling that you cannot automate the data export process either. So I suspect the best you can do is something that achieves the same results. http://www.slipstick.com has some samples that you may find useful. If you search Google Groups for Peter Jamieson Inspector you may find an article of mine around Oct 2002 that has some code to generate Word documents from /individual/ contacts. It doesn't use Mail merge though. Peter Jamieson "Jef Gorbach" wrote in message ... Co-worker running Word97 mailmerges from his Outlook2000 contact folder several times a week/month so would like to automate the process. Sounds simple, but Outlook lacks the macro recorder so need help with the underlying vba; especially since whomever loaded Outlook omitted installing Outlook's vba help file. Havent had much luck with Google/Usenet on this yet, encountering numerous reccomendations to start the merge from Outlook...however the few postings found regarding automating this process imply it cant be done....although there are plenty of examples confirming there ARE contact list properties/methods so it should be possible?? One vba example from (misplaced url) indicates it does this, however imports the selected Outlook97 contacts into an Access97 table then mailmerges from it. Unfortunately we dont have Access. The manual screens imply its essentially: With selected Contacts mail merge using only selected contacts to existing document (say c:\desktop\sales letter form.doc) merge option: form letter merge to new document end with so presumably we could resort to a WSH Sendkeys routine but shouldnt this be possible for a VBA routine WITHIN either Outlook or Word ?? |
#3
|
|||
|
|||
Thanks for confirming my conclusion and suggestions. Wonder why the Outlook Team didnt "finish" VBA like the Excel/Word Teams did?? "Peter Jamieson" wrote in message ... If your co-worker is already using Outlook Tools|Mail Merge to initiate the merge, I think the basic problem is that Outlook VBA does not have the methods to replicate that particular process programmatically. In fact there are quite a lot of things you can do manually in Outlook that do not have corresponding methods in Outlook VBA - for example, I have a feeling that you cannot automate the data export process either. So I suspect the best you can do is something that achieves the same results. http://www.slipstick.com has some samples that you may find useful. If you search Google Groups for Peter Jamieson Inspector you may find an article of mine around Oct 2002 that has some code to generate Word documents from /individual/ contacts. It doesn't use Mail merge though. Peter Jamieson "Jef Gorbach" wrote in message ... Co-worker running Word97 mailmerges from his Outlook2000 contact folder several times a week/month so would like to automate the process. Sounds simple, but Outlook lacks the macro recorder so need help with the underlying vba; especially since whomever loaded Outlook omitted installing Outlook's vba help file. Havent had much luck with Google/Usenet on this yet, encountering numerous reccomendations to start the merge from Outlook...however the few postings found regarding automating this process imply it cant be done....although there are plenty of examples confirming there ARE contact list properties/methods so it should be possible?? One vba example from (misplaced url) indicates it does this, however imports the selected Outlook97 contacts into an Access97 table then mailmerges from it. Unfortunately we dont have Access. The manual screens imply its essentially: With selected Contacts mail merge using only selected contacts to existing document (say c:\desktop\sales letter form.doc) merge option: form letter merge to new document end with so presumably we could resort to a WSH Sendkeys routine but shouldnt this be possible for a VBA routine WITHIN either Outlook or Word ?? |
#4
|
|||
|
|||
I don't know what happened to Outlook VBA, which was a relatively late
addition to Outlook. However, my best guess is that MS may think that any increase in Outlook programmability is a potential source of new security problems and therefore to be avoided. Peter Jamieson "Jef Gorbach" wrote in message ... Thanks for confirming my conclusion and suggestions. Wonder why the Outlook Team didnt "finish" VBA like the Excel/Word Teams did?? "Peter Jamieson" wrote in message ... If your co-worker is already using Outlook Tools|Mail Merge to initiate the merge, I think the basic problem is that Outlook VBA does not have the methods to replicate that particular process programmatically. In fact there are quite a lot of things you can do manually in Outlook that do not have corresponding methods in Outlook VBA - for example, I have a feeling that you cannot automate the data export process either. So I suspect the best you can do is something that achieves the same results. http://www.slipstick.com has some samples that you may find useful. If you search Google Groups for Peter Jamieson Inspector you may find an article of mine around Oct 2002 that has some code to generate Word documents from /individual/ contacts. It doesn't use Mail merge though. Peter Jamieson "Jef Gorbach" wrote in message ... Co-worker running Word97 mailmerges from his Outlook2000 contact folder several times a week/month so would like to automate the process. Sounds simple, but Outlook lacks the macro recorder so need help with the underlying vba; especially since whomever loaded Outlook omitted installing Outlook's vba help file. Havent had much luck with Google/Usenet on this yet, encountering numerous reccomendations to start the merge from Outlook...however the few postings found regarding automating this process imply it cant be done....although there are plenty of examples confirming there ARE contact list properties/methods so it should be possible?? One vba example from (misplaced url) indicates it does this, however imports the selected Outlook97 contacts into an Access97 table then mailmerges from it. Unfortunately we dont have Access. The manual screens imply its essentially: With selected Contacts mail merge using only selected contacts to existing document (say c:\desktop\sales letter form.doc) merge option: form letter merge to new document end with so presumably we could resort to a WSH Sendkeys routine but shouldnt this be possible for a VBA routine WITHIN either Outlook or Word ?? |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Mail Merge Word 2003 Issue | Mailmerge | |||
mail merge with attachments | Mailmerge | |||
Problem with automating mail merge | Mailmerge | |||
Mail Merge Issue With Office 97 - Excel Data Source | Mailmerge | |||
Word-Excel 2003 - Mail Merge Recipients problem | Mailmerge |