J
Jef Gorbach
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
I've uncovered 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 WSH Sendkeys routine but shouldnt this be
possible WITHIN Outlook?
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
I've uncovered 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 WSH Sendkeys routine but shouldnt this be
possible WITHIN Outlook?