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

Why are there 1,048,576 rows in Excel?
The Excel team increased the size of the grid in 2007. There are 2^20 rows and 2^14 columns for a total of 17 billion cells.

Forum statistics

Threads
1,224,823
Messages
6,181,175
Members
453,021
Latest member
Justyna P

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