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 strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

trying to automate email text dumps into fields!

Status
Not open for further replies.

bricklebrit

Technical User
Mar 2, 2002
26
US
Hello!

I'm wanting to set up a automated form button to cut out automated emails I receive and splice the information into separate field in the customers

I get the same standard raw information such as:
Billing Information--------
Name: Mike Lopaplois
Address1: 153359 Great Mill Rd
Address2:
City: Wooleybridge
Postal Code: 22191
State/Provence: VA
Country: US
Email: miike@aol.com
Phone: 713-513-1132

Is it possible to script a button to truncate the opening data (pasted in to the value [textDump(such as "NAME:", but cut all this vital data into the values in my [Customers] table - so it would read as:
"Name: Mike Lopaplois" -> [CustomerName]
"Address1: 153359 Great Mill Rd (and)
Address2:" -> [ShipAddress1]
"City: Wooleybridge" -> [ShipCity]
"Postal Code: 22191" -> [ShipZip]
"State/Provence: VA" -> [ShipState]
"Country: US" -> [Ship Country]
"Email: miike@aol.com" ->
"Phone: 713-513-1132" -> [Phone]

Right now, I'm copying and pasting each value which is a tedious task - any examples or advice are whole-heartidly welcomed!

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top