Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to start participating now! Also, be sure to check out the New User Guide.
Export from Outlook to Excel
Name: clomper Date: January 26, 2004 at 10:58:06 Pacific OS: Win XP Home CPU/Ram: 2.8Ghz/512Mb
Comment:
I have an online form that submits to my email account. The information filled out by the visitor shows up in the body of a message that looks similar to this:
vfname: John vlname: Doe vaddress1: 1234 Sleepy Hollow Dr. vcity: Allentown vstate: PA vzip: 12345
I need an (Outlook?) macro to export this information to an Excel workbook that has column headings that correspond to the above fields. Can anyone get me started on the best method for this operation?
Name: chnos Date: January 27, 2004 at 08:38:57 Pacific
Reply:
No macro needed. Select all, copy in wordpad ans save as .txt. Next open it with excel, conversion/import tool will open automatically. Follow instructions.Next, if text is still like in the message, choose copy/special paste/transposition. That's done. I did it with ur message's body, via word: proceed ok.
0
Response Number 2
Name: clomper Date: January 27, 2004 at 14:18:02 Pacific
Reply:
That's an OK solution for a single email, but I have several hundred of these emails a day. See now why I need a macro? It's possible that this is too complicated a task for this forum. It's definitely too complicated for me!!
Summary: I am exporting my emails from Outlook to excel, and it is almost fine, but the date (received/sent) doesn't come along. Only these fields: Subject Body FromName FromAddress FromType ToName ToAddress T...
Summary: Is the Excel file already open when you use the hyperlink from Word and/or Outlook? Here's why I ask... I did some testing and found that the link in Word will only select the cells in the hyperlink i...
Summary: You referred to the From Address field. My exports work properly. How exactly are you exporting from Outlook? And are you exporting the entire Inbox or do you have your read receipts in a folder of...
0 
