Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations sizbut on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Best method to get data from an MS outlook e-mail to Excel

Status
Not open for further replies.

daseffects

Technical User
Aug 21, 2003
38
GB
Hi,

We're looking for the most effective way of capturing data in an MS Outlook e-mail and then having the ability to export the data to an Excel file (convert form input into a row of Excel data)

Our initial thought was to create a form in outlook and then use some macros to export to Excel. Our 2nd thought was that we might be able to e-mail an embedded Excel form that could then just copy the information to the Excel file with a button.

Before going down either route does any one have any views into the most effective solution/method.

Thanks,

David
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top