Macro- How to set CC on emails from receiver

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
 
G

Graham Mayor

You would need to set this up as a rule in Outlook to forward the mail to
the third party.

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP

My web site www.gmayor.com

<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
 
G

Guest

Hi Graham,

Thanks for your advice.

Before I setup this action in rules, I wanted to check one thing. In an
Outlook message, under message and delivery options, there is a field to
insert names that you want the recipient's reply to be sent to. Is it
possible to use this field in a macro?

Thanks again.

Georgie
 

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