Celebrate National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

outlook 2007 VBA code to extract ....

Posted on 2014-09-27
7
Medium Priority
?
344 Views
Last Modified: 2014-10-19
My OS is win 7 prof 64 bit, I use office 2007.  I want to locate the IP address of an email.  But I cannot seem to find the message button in my Outlook 2007, and I was researching Message ID 19737453 but the code bombed at :
 Dim safe_email As Redemption.SafeMailItem
The error was ; Could not find object or Library.
My purpose is to find the IP address of emails, preferably when I highlight the email and run the macro.  Will Chris' VBA code work for this?  Thank u for your suggestions.
0
Comment
Question by:jegajothy
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 3
7 Comments
 
LVL 37

Accepted Solution

by:
Neil Russell earned 2000 total points
ID: 40347614
Have you got the Redemption Libraries installed?

http://www.dimastr.com/redemption/home.htm
0
 

Author Comment

by:jegajothy
ID: 40347678
In response to Neilsr, thank u for your suggestion.   I downloaded the single version - is this the right file to download and install?, but how does it get installed  After running the file, I looked at "References" of the vba, and I did not see anything called Redemption or Collaboration Data ....  Hope u can please walk me thru this process. Thank u.
0
 
LVL 37

Assisted Solution

by:Neil Russell
Neil Russell earned 2000 total points
ID: 40347781
The stand alone version states that it is for use on a server when Outlook is NOT installed.  You say you're developing this code in outlook client?  if so you need to download and install the developer edition.
0
Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

 

Author Comment

by:jegajothy
ID: 40349119
In response to Neilsr, thank u for your advice.  I have since installed the developer edition.  The code runs now without an error.  I selected an email, then ran the macro, but I do not see the IP address displayed anywhere.  hope someone can please advise how the IP is displayed.  Thank u.
0
 
LVL 37

Expert Comment

by:Neil Russell
ID: 40349738
Please post your completed code here
0
 

Author Comment

by:jegajothy
ID: 40349870
in response to Neilsr, attached is the code as a file.  It is a Macro.  The way I run it is first I highlight the email message which is in my Inbox, then I hit the Macro, and Run it.  But it does nothing.  
I was wondering if the IP addresses can be saved to a text file, with the email address and the IP address.
Thank u for your assistance.
Code-for-looking-up-IP-address-for-outlo
0
 

Author Closing Comment

by:jegajothy
ID: 40391099
thank u.
0

Featured Post

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Make the most of your online learning experience.
We live in a world of interfaces like the one in the title picture. VBA also allows to use interfaces which offers a lot of possibilities. This article describes how to use interfaces in VBA and how to work around their bugs.
In this fifth video of the Xpdf series, we discuss and demonstrate the PDFdetach utility, which is able to list and, more importantly, extract attachments that are embedded in PDF files. It does this via a command line interface, making it suitable …
Many of my clients call in with monstrous Gmail overloading issues with Outlook. A quick tip is to turn off the All Mail and Important folders from synching. Here is a quick video I made to show you how to turn off these and other folders in Gmail s…

730 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question