View Single Post
Old 09-28-2010, 04:56 PM
scadaman29325 scadaman29325 is offline Windows XP Office 2007
Join Date: Sep 2010
Posts: 5
scadaman29325 is on a distinguished road
Default parse, store and email a .tmp file from wordpad?

When our billing system "prints" to the screen, it opens Wordpad with an xyz.tmp file. Basically a text file with name, address...

The desired final result is to parse (?) the file for certain information, store the data in an access db and send the data to an email address. All based on data in the file and with just one more click?

Can this be automated?

Can the file be "sent" or "printed" to a db and the db do the magic? Maybe through Excel? Through Outlook?

Is this feasible? Possible?

Btw, I've done some vba in excel and access. Just enough to be real dangerous.

All help is appreciated, thanks,
Reply With Quote