ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Attaching a Read Receipt to Outlook E-mail (https://www.excelbanter.com/excel-programming/422556-attaching-read-receipt-outlook-e-mail.html)

DS

Attaching a Read Receipt to Outlook E-mail
 
Afternoon all,

I'm using some of RDB's code, suitably modified, to send e-mails via an
Excel / VBA control. All works just fine for sending multiple workbooks to
multiple locations, etc etc.

However, I've just had a spanner thrown in the works, in that these now
require Read Receipts attached to the e-mails.

This is the basic create / send routine after the body, title etc has been
created:

With OutMail
.SentOnBehalfOfName = """Mike"" "
.To = "
.CC = ""
.BCC = ""
.Subject = "Details as Requested"
.Body = strbody
.Display
Application.Wait (Now + TimeValue("0:00:02"))
Application.SendKeys "%S"
End With

I figure that I need to add in something along the lines of:
.AttachReadReceipt = True

unfortunately, every combination I can think of and have tried is not
actually attaching one.

Can anyone advise what I should use for this?

Many Thanks in Advance,
Mike

Ron de Bruin

Attaching a Read Receipt to Outlook E-mail
 
Hi DS

See the tips page
http://www.rondebruin.nl/mail/tips2.htm

You can use

Set Importance

' 0 = Low, 2 = High, 1 = Normal
.Importance = 2


ReadReceiptRequest

.ReadReceiptRequested = True



--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"DS" wrote in message ...
Afternoon all,

I'm using some of RDB's code, suitably modified, to send e-mails via an
Excel / VBA control. All works just fine for sending multiple workbooks to
multiple locations, etc etc.

However, I've just had a spanner thrown in the works, in that these now
require Read Receipts attached to the e-mails.

This is the basic create / send routine after the body, title etc has been
created:

With OutMail
.SentOnBehalfOfName = """Mike"" "
.To = "
.CC = ""
.BCC = ""
.Subject = "Details as Requested"
.Body = strbody
.Display
Application.Wait (Now + TimeValue("0:00:02"))
Application.SendKeys "%S"
End With

I figure that I need to add in something along the lines of:
.AttachReadReceipt = True

unfortunately, every combination I can think of and have tried is not
actually attaching one.

Can anyone advise what I should use for this?

Many Thanks in Advance,
Mike


DS

Attaching a Read Receipt to Outlook E-mail
 
Ron, once again I am in your debt.... works like a charm, thank you.
Mike

"Ron de Bruin" wrote:

Hi DS

See the tips page
http://www.rondebruin.nl/mail/tips2.htm

You can use

Set Importance

' 0 = Low, 2 = High, 1 = Normal
.Importance = 2


ReadReceiptRequest

.ReadReceiptRequested = True



--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"DS" wrote in message ...
Afternoon all,

I'm using some of RDB's code, suitably modified, to send e-mails via an
Excel / VBA control. All works just fine for sending multiple workbooks to
multiple locations, etc etc.

However, I've just had a spanner thrown in the works, in that these now
require Read Receipts attached to the e-mails.

This is the basic create / send routine after the body, title etc has been
created:

With OutMail
.SentOnBehalfOfName = """Mike"" "
.To = "
.CC = ""
.BCC = ""
.Subject = "Details as Requested"
.Body = strbody
.Display
Application.Wait (Now + TimeValue("0:00:02"))
Application.SendKeys "%S"
End With

I figure that I need to add in something along the lines of:
.AttachReadReceipt = True

unfortunately, every combination I can think of and have tried is not
actually attaching one.

Can anyone advise what I should use for this?

Many Thanks in Advance,
Mike




All times are GMT +1. The time now is 05:41 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com