I have been looking for a macro which will extract data from the currently highlighted email in outlook and append it to a specified worksheet in an Excel workbook.
If the incoming body contains
Name: Joe Bloggs
Age:32
then the macro should send the data to the next empty row in the sheet.
Does anyone know how I can do this or provide a link with some examples to work from.
tia
is this for a personal solution for or has it got to work within a corporate network and exchange server?
How will the workbook be identified?
Is it always the same data?
Is the incoming email a fixed format?
It all affects how to tackle the solution.
click on the * Add Reputation if this was useful or entertaining.
The solution is a personal one on a stand alone PC.
The data is always in the same format and the only changes are in the values of the data.
OK,
but I can only be half helpfulas I don't have outlook installed on this PC.
Basically there are two options: 1. write an excel macro to get the data from Outlook and 2. write an Outlook macro to push the data to Excel.
in your case you will be better off with an Outlook Macro. You will need to add Excel as a reference in tools. and makesure you decalre Range object with the full class name or you will have problems.
I think when you install Outlook it doesn't install all the programming part unless you specifically request it.
If you are still stuck in a week ask me again I might be back with another PC.
I have a similar issue but have never created a macro for Outlook or Excel.
I have 2 forms on the web that are sent to an email box/folder. When I export them chosing only the body as a Windows Tab Delimited text file there is a lot of other information that goes into the cells not just the form field information. Here are the two forms.
Form 1
First Name:
Last Name:
Your e-Mail Address:
Program Confirmation Number:
Form 2
First Name:
Last Name:
Your e-Mail Address:
Participation Verification Code:
It would be great to be able to append the information into Excel but I would settle for just getting the field information cleanly into columns. If anyone has a macro that I can use as a starting point it would be very helpful.
Thanks,
Denny
I have trawled the net looking for anything that would let me move just one item of data.
It would give me a start and I would have something to work with.
I can't believe that so few people would find this useful that no-one would create such a macro.
If you do this from Outlook you will not run into security issues. If you do this from Excel or some other program Office will throw up warning messages every time you try to read the body of the email.
This would work from Outlook - but you could change it to work from excel as well
you could even add this as a button in outlook. Then just select a message and press the button.
Please Login or Register to view this content.
We are holding an event. To register members will fill out a form online which will be emailed to me. I am looking for a macro code to automatically export the registration information into a excel spreadsheet. Here is a copy of what the email looks like when I receive it.
The submitted value of field named "Member Name:" is:
-------------------------------------------------------
Test Run
-------------------------------------------------------
The submitted value of field named "Member #:" is:
-------------------------------------------------------
m115
-------------------------------------------------------
The submitted value of field named "Club:" is:
-------------------------------------------------------
PRC
-------------------------------------------------------
The submitted value of field named "Phone:" is:
-------------------------------------------------------
555-555-555
-------------------------------------------------------
The submitted value of field named "Email:" is:
-------------------------------------------------------
[email protected]
-------------------------------------------------------
kjm1, Welcome to the Forum.
Unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.
If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.
Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.
Ben Van Johnson
see if this helps..
Please Login or Register to view this content.Please Login or Register to view this content.
Last edited by arlu1201; 06-05-2013 at 06:55 AM.
Welcome to the forum.
I have added code tags to your post. As per forum rule 3, you need to use them whenever you put any code in your post. Please add them in future. In order to put code tags, either type [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] at the end of it, OR you can highlight your code and click the # icon at the top of your post window.
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks