How do I get read & delivery receipts for an Email merge?

S

Sooz

I have created a Word (2003) document and sent it via Outlook (2003) using
the mail merge function. The emails were sent successfully as far as I know,
however, to be sure they were sent and read, I checked the boxes for read and
delivery receipt in the Tools/Option within my email document . I did not
receive any delivery or read receipts. Is there something else I should do?
 
P

Peter Jamieson

If you started with an "email document", I do not think Word will honour
any of the e-mail related settings in that document - it probably only
looks at the ones you set in the dialog that starts the merge to email.

So...

One way you could approach this (I haven't tested the code here):

Set all the read/delivery receipts in Outlook, e.g.
a. before the merge, ensure your Outlook Outbox is empty, then stop
Outlook from sending. Leave Outlook open
b. do the merge
c. run the following macro. It should work from both Outlook and Word,
but in Word you will need to ensure that there is a reference to the
Microsoft Office xx.0 Outlook Library (with the VBA macro open in the
VBE Editor, use Tools|References to check the appropriate version of the
library).

Sub MarkAllInOutbox()

Dim objOutlook As Outlook.Application
Dim objNameSpace As Outlook.NameSpace
Dim objFolder As Outlook.Folder
Dim objMailItem As Outlook.MailItem
Set objOutlook = GetObject(, "Outlook.Application")
Set objNameSpace = objOutlook.GetNamespace("MAPI")
Set objFolder = objNameSpace.GetDefaultFolder(olFolderOutbox)
For Each objMailItem In objFolder.Items
objMailItem.ReadReceiptRequested = True
objMailItem.OriginatorDeliveryReportRequested = True
objMailItem.Save
objMailItem.Send
Next
Set objFolder = Nothing
Set objNameSpace = Nothing
Set objOutlook = Nothing
End Sub

d. Start Outlook sending again.

There is another possible approach that does one merge for each email,
but it would be handy to know whether you are sending as plain text,
HTML or attachment - and it may have problems with Outlook security prompts.


Peter Jamieson

http://tips.pjmsn.me.uk
 
R

Rich/rerat

Sooz,
Remember that many individuals have their mail application set to not accept
"Read Receipt" requests, in addition, some ISP/Mail services also block
these requests. So the only thing that you can do, is to put in the body of
the letter/message, a request to send a reply, notifying you that they have
received and read your letter/message.


--
Add MS to your News Reader: news://msnews.microsoft.com
Rich/rerat
(RRR News) <message rule>
<<Previous Text Snipped to Save Bandwidth When Appropriate>>


I have created a Word (2003) document and sent it via Outlook (2003) using
the mail merge function. The emails were sent successfully as far as I
know,
however, to be sure they were sent and read, I checked the boxes for read
and
delivery receipt in the Tools/Option within my email document . I did not
receive any delivery or read receipts. Is there something else I should do?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top