Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Word / Mailmerge and Fax / January 2007

Tip: Looking for answers? Try searching our database.

Mail merge and polling buttons

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Richard - 25 Jan 2007 19:42 GMT
I know this may be impossible; howeve, I would like to use the polling option
for a mailmerge email I am writing.  Has anyone done this already?
If so how?
Thank you.
Peter Jamieson - 25 Jan 2007 21:41 GMT
I have never done it, but you can't really control Outlook during a Word
mailmerge. However, you can either
a. use a Word macro to simulate a Word mailmerge and generate Outlook mail
messages or
b.
   - flush your Outbox, then set up Outlook to stop sending e-mails
   - perform the merge so that your e-mails end up in the Outbox
   - use an Outlook macro to process each e-mail in the Outbox so that it
has a voting option
   - set up Outlook so it starts sending e-mails again.

I leave you to work out how to do steps 1,2, and 4 of option (b) and how to
set up Outlook so that it can execute Outlook VBA code, but some very crude
Outlook VBA code is as follows:

Sub setvote()
Dim NS As Outlook.NameSpace
Dim oFolder As Outlook.MAPIFolder

Dim oMessage As MailItem
Set NS = Outlook.GetNamespace("MAPI")
For Each oMessage In NS.GetDefaultFolder(olFolderOutbox).Items
 oMessage.VotingOptions = "red;amber;green"
 oMessage.Save
 oMessage.Send
Next
Set NS = Nothing
End Sub

For option (a), I suggest you look at the following article by Doug Robbins
(which may be overkill for your purposes, or may be just the ticket), and
work out how to modify the messages it generates using the above sample
code:

http://word.mvps.org/FAQs/MailMerge/MergeWithAttachments.htm

Peter Jamieson

>I know this may be impossible; howeve, I would like to use the polling
>option
> for a mailmerge email I am writing.  Has anyone done this already?
> If so how?
> Thank you.
Richard - 26 Jan 2007 13:48 GMT
Peter, Thank you for the reply, I will keep this info in case I need it in
the future; however, at this point I am dealing wtih 6 emails, seems like
overkill to do that for 6, instead I will use the mail merge and send each
individually.

> I have never done it, but you can't really control Outlook during a Word
> mailmerge. However, you can either
[quoted text clipped - 39 lines]
> > If so how?
> > Thank you.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.