G
Guest
I have a macro that creates an Outlook message and attaches the active
document. I've now been asked if it is possible to code the outgoing email so
that when the receiver replies to the message, a CC goes to a third person.
We do not want the third person to receive the outgoing emails, just the
response emails. Is this possible? I've included my current macro below.
Thanks!
Georgie
Sub Mail_document_Outlook()
Dim OutApp As Outlook.Application
Dim OutMail As Outlook.MailItem
Set OutApp = CreateObject("Outlook.Application")
Set OutMail = OutApp.CreateItem(olMailItem)
With OutMail
.To = ""
.CC = ""
.BCC = ""
.Subject = "Subject line" + ActiveDocument.Name
.Body = ""
.Attachments.Add ActiveDocument.FullName
.Display
End With
Set OutMail = Nothing
Set OutApp = Nothing
End Sub
document. I've now been asked if it is possible to code the outgoing email so
that when the receiver replies to the message, a CC goes to a third person.
We do not want the third person to receive the outgoing emails, just the
response emails. Is this possible? I've included my current macro below.
Thanks!
Georgie
Sub Mail_document_Outlook()
Dim OutApp As Outlook.Application
Dim OutMail As Outlook.MailItem
Set OutApp = CreateObject("Outlook.Application")
Set OutMail = OutApp.CreateItem(olMailItem)
With OutMail
.To = ""
.CC = ""
.BCC = ""
.Subject = "Subject line" + ActiveDocument.Name
.Body = ""
.Attachments.Add ActiveDocument.FullName
.Display
End With
Set OutMail = Nothing
Set OutApp = Nothing
End Sub