ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Need help with insert text file Macro (https://www.excelbanter.com/excel-programming/335149-need-help-insert-text-file-macro.html)

Ben79

Need help with insert text file Macro
 

I receive order information in e-mails ( one order in each e-mail) and
want to import this information into an excel sheet. Is it possible t
save the e-mail as a text file and then create a macro that imports i
automatically?

The e-mails looks about like this

Order number
Name
Address
Zip/city
Country
Price
Product Code

I would want each of these lines to appear in different columns (on
row for each order)

Anybody that can help

--
Ben7
-----------------------------------------------------------------------
Ben79's Profile: http://www.excelforum.com/member.php...fo&userid=2545
View this thread: http://www.excelforum.com/showthread.php?threadid=38900



All times are GMT +1. The time now is 03:52 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com