Solved

email and link into excel vba

Posted on 2014-04-13
3
391 Views
Last Modified: 2014-04-27
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
Comment
Question by:BostonBob
3 Comments
 
LVL 35

Accepted Solution

by:
Bembi earned 500 total points
ID: 39997504
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
 

Author Comment

by:BostonBob
ID: 39997510
Oh lead me to the promised land....

Can you give me a working example? Thanks!
0

Featured Post

What Should I Do With This Threat Intelligence?

Are you wondering if you actually need threat intelligence? The answer is yes. We explain the basics for creating useful threat intelligence.

Join & Write a Comment

Deploying a Microsoft Access application in a Citrix environment is not difficult but takes a few steps. However, Citrix system people are often of little help, as they typically know next to nothing about Access. The script provided here will take …
This article descibes how to create a connection between Excel and SAP and how to move data from Excel to SAP or the other way around.
The viewer will learn how to  create a slide that will launch other presentations in Microsoft PowerPoint. In the finished slide, each item launches a new PowerPoint presentation and when each is finished it automatically comes back to this slide: …
This Micro Tutorial will demonstrate how to use longer labels with horizontal bar charts instead of the vertical column chart.

762 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

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now