Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 419
  • Last Modified:

email and link into excel vba

Hi All,

I have a interesting problem that I have no idea where to begin.

If we have a user that sends in an email that has the following information:
1. Time it was sent
2. Location by Link (Example:  http://goo.gl/maps/2N2tK or by http://maps.apple.com/?ll=51.010969,-114.041481)

Is it possible to receive an email and then automatically download the email into vba excel where we can get the:

Time the email was sent AND an Approximate address (from the link).

Thanks for your help!
0
BostonBob
Asked:
BostonBob
1 Solution
 
BembiCEOCommented:
Just a point to start from. Each windows server allows a native SMTP server. This SMTP server can be addressed (i.e forwared) and the server just throws emails into a local folder.
From this folder you can open the email file as a text file and filter the information out you need via vba code.
0
 
BostonBobAuthor Commented:
Oh lead me to the promised land....

Can you give me a working example? Thanks!
0

Featured Post

Free recovery tool for Microsoft Active Directory

Veeam Explorer for Microsoft Active Directory provides fast and reliable object-level recovery for Active Directory from a single-pass, agentless backup or storage snapshot — without the need to restore an entire virtual machine or use third-party tools.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now