Screen Scrape Sender IP Address

Mize

New Member
Outlook version
Outlook 2016 64 bit
Email Account
Exchange Server
#1
Looking for a VBA Script that can use Outlook 2016 Message Options to screen scrape "Sender IP Address" and post either in Excel or Word for further review.
 
Outlook version
Outlook 2016 32 bit
Email Account
Office 365 Exchange
#2
You'll want to start with this - Use a Macro to Copy Data in an Email to Excel - and I thought I had a macro that grabbed data from the header. I'll see if I can find it. If the sender ip is not in a propertyaccessor, you need to use regex to grab it.
 

Mize

New Member
Outlook version
Outlook 2016 64 bit
Email Account
Exchange Server
#5
Diane...hi! Happy New Year. Hope your holidays were fantastic. Recall above you provided a VBA to allow identification of Sender IP Addresses from Outlook. I'm running Outlook 2016 Desktop. I'm unfortunately not a programmer. I'm looking for a little help. I installed the VBA for the headers capture. It was installed as Module 2. When I try to run it, I receive the following error.
1548539730760.png
I go to the Macros section of the Developer pane I have ensured that macros are enabled. Doing so, still won't execute the VBA. Looking for your guidance on how to move this forward. Thanks in advance....Dan
 
Outlook version
Outlook 2016 32 bit
Email Account
Office 365 Exchange
#6
Did you change macro security in File, options, trust center, macro security and restart Outlook? Changing the macro security should be all you need to do.
 

Mize

New Member
Outlook version
Outlook 2016 64 bit
Email Account
Exchange Server
#7
1548621137660.png

Yes...the macro security in File, options, trust center was set correctly to Enable; however I had not restarted Outlook. So I did that today. I was able to run the macro. It appears to have two options. See above. I'm not sure of the difference between the two; however, when I run GetValuesFromInternetHeader, the operation returns a new email screen with what appears to be an email address in the body. See below. Appreciate any suggestions on what to do at this point.
1548621489242.png


1548621403896.png
 

Similar threads

Top