Not receiving a return receipt when using SendMail

[LeighAnne]

I follow the values through the code and the variable AReceipt does set to True if the user presses Yes in the message box, however when the email is sent the receipt is never received. Here is the code I am using:

'Does the user want a receipt
ReceiptRequired = MsgBox("Would you like a return receipt?", vbYesNo, "Return Receipt")
If ReceiptRequired = 6 Then
AReceipt = True
Else
If ReceiptRequired = 7 Then
AReceipt = False
End If
End If
ActiveWorkbook.SendMail Recipients:=Array(strRecipients), Subject:=Client & " " & Project & " PCS " & number & "", ReturnReceipt:=AReceipt

 

[LeighAnne]

I still require help with this post!

Does anyone know how to get a read or delivery receipt when sending an excel workbook from vba? The code seems fine, but the receipt never arrives.

Could it be something to do with my outlook settings?

If the receipt boxes have to be ticked in my tracking options in outlook, then i'll receive them for every email that is sent, I only want them when this macro is used.

Help please! This is driving me insane!

 

[KenWright]

You may only get the receipt notification if the recipient allows it. In Outlook 2000 I used to be able to request receipts and as soon as the message was opened I got it, but when we went to Outlook 2002 it changed to allow the recipient the option of returning the receipt or not. Don't know if it's linked to anything to do with the server or not, but I only noticed when we got upgaraded. I now almost always say no because it bugs me when people do that, so if you are on 2002 just be sure people aren't telling the system not to send them.

Regards
Ken................

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission

----------------------------------------------------------------------------

 

[TonyJollans]

Hi LeighAnne,

As Ken says, it depends on the recipient. A read receipt is an e-mail which the recipient may or may not send.

Whether it is automatically sent is probably a result of the e-mail client options.

In Outlook 2000, under Tools > Options > EMail Options button > Tracking Options button you have the choice as to whether to send receipts always, never, or subject to prompt - I have mine set to prompt (so I can see who's asking) but only send them if I think the request is reasonable and I'm not going to reply otherwise.

Enjoy,
Tony

--------------------------------------------------------------------------------------------
We want to help you; help us to do it by reading this: Before you ask a question.
Excel VBA Training and more Help at [url=http://www.vbaexpress.

 

[KenWright]

It wasn't until people started doing it to me that i realised how bugging it was, and I almost always kill them now out of sheer annoyance, and I don't ask for them myself anymore now either.

Regards
Ken.................

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission

----------------------------------------------------------------------------

 

[LeighAnne]

Thanks guys!

At least I don't have to spend hours trying to work out where I was going wrong!

Le