Home>

We are VBA beginners.
In the automatic draft creation tool (created with Excel macro) that has been handed over at work,
We would like to add "Reply-to address specification function" (Reference: https://www.helpforest.com/office/ol_config/ol010003.htm).

Specifically, send an email (sender: yourself) generated on the Outlook app with the Excel macro (oApp.CreateItem) in Outlook,
When a recipient presses "Reply All" or "Reply", I want to force the email address to be different from the sender.

I'm very sorry, but if you know how to write VBA,
I would appreciate it if you could tell me.

  • Answer # 1

      

    MailItem.ReplyRecipients property (Outlook)

    I think it can be set with the following description.

    Const AlterReplyAddress = "[email protected]"
    Dim m As Outlook.MailItem
    '...
    'https://msdn.microsoft.com/en-us/VBA/Outlook-VBA/articles/mailitem-replyrecipients-property-outlook
    Call m.ReplyRecipients.Add (AlterReplyAddress)

  • Answer # 2

    If you create an email body in Excel and send it outlook, it is not an Excel VBA area.
    If it is Outlook VBA, it is good to set reply-to header while referring to this. (Unverified)