D
DS
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"" <[email protected]>"
.To = "(e-mail address removed)"
.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
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"" <[email protected]>"
.To = "(e-mail address removed)"
.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