Simple VBA for Outlook - Copy last sent email

spacecaptainsuperguy

Board Regular
Joined
Dec 30, 2004
Messages
202
Office Version
  1. 365
Platform
  1. Windows
I've done some VBA in Excel, but never in Outlook and am hopeful I can get some pointers.

I'm looking to create a simple macro that will do the following (sub-bullets to help explain what I'm currently doing manually):
  • Open the most recently sent email and "forward" it.
    • By "Forward" it, I am looking to capture the header information you see when you forward an email (the From:, Sent:, To: & Subject: info). There may be a way to get this info in VBA...however forwarding it is how I've been getting it manually.
  • Copy everything in the email from the word From: down to the bottom.
    • when I'm manually doing this, From: is the first word after my signature line of the new forwarded email. Again...there may be an easier/cleaner way to do this in VBA....I'm simply trying to explain what I'm doing manually so hopefully that helps.
  • Close the forwarded email and do not save
That's it. I am trying to find a simple way to copy and paste this information into another program we use to log conversations. In a perfect world, I'd be able to run this macro in Outlook after sending the email and then jump over to our other program and simply paste it there.

Thanks in advance for any assistance.
 

Excel Facts

How to change case of text in Excel?
Use =UPPER() for upper case, =LOWER() for lower case, and =PROPER() for proper case. PROPER won't capitalize second c in Mccartney

Forum statistics

Threads
1,215,071
Messages
6,122,964
Members
449,094
Latest member
Anshu121

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top