Yoan_Geneva
New Member
- Joined
- Nov 8, 2018
- Messages
- 1
Dear members,
I am trying to forward an outlook email to multiple adresses with a vba macro in excel.
Why in excel ? Becase all the email adresses are in the excel file.
I want to forward an email that I received. I want to forward the exact same email (i.e. without the usual lines when you click "forward" in outlook
From: Martin Dupont
Sent: Thursday...
To: Martin Dupont
Subject: Test
For now, I have the following code:
But with this code I can't manipulate the body of the email (i.e. I can't delete the lines that appear when you forward an email).
Thanks for your help.
Yoan
I am trying to forward an outlook email to multiple adresses with a vba macro in excel.
Why in excel ? Becase all the email adresses are in the excel file.
I want to forward an email that I received. I want to forward the exact same email (i.e. without the usual lines when you click "forward" in outlook
From: Martin Dupont
Sent: Thursday...
To: Martin Dupont
Subject: Test
For now, I have the following code:
Code:
Sub Forward_Current_Email
Dim outForward as Outlook.MailItem
Set outForward= ActiveExplorer.Selection.item(1)
outForward.display
outforward.to="martin.dupont@hotmail.fr"
outForward.send
End sub
But with this code I can't manipulate the body of the email (i.e. I can't delete the lines that appear when you forward an email).
Thanks for your help.
Yoan