Macro to Copy data from e-mail and paste it into a field on a website

J

joebobcletusjr

This one may be quite a challenge, if it is at all possible.

First I would like to say that this website is definetely the best
information source for Exel help I have been able to find anywhere.

What I am trying to do is a little difficult to explain, so please bear
with me.

I recieve form e-mails from my customers that includes contact
information, and most importantly a phone number that needs to be
pre-qualified for DSL service.

The format is below:

name : XXXXXXXXXX
streetaddress : XXXXXXXXXX
city : XXXXXXXXXX
state : XX
zip : XXXXX
areacode :XXX
phone1 : XXX
phone2 : XXXX
contact_time : M-F, 5-6pm
areacode2 : XXX
phone12 : XXX
phone22 : XXXX
email : (e-mail address removed)
Submit : Go

Option 1

I need a macro to open these e-mails, and copy (select all and copy)
the information into Excel with the "Name", "Street address"... in
column A, and the "XXXXXX" (Customer input information) in column B.

Then I need an Excel macro that will copy only the numbers in column B
next to "Area code", "phone1", and "phone2", and paste it into a field
in a webpage that I can specify.

Option 2

May be easier, (once again, if possible)

If the macro can copy only the customer input (XXX) after "Areacode",
"Phone1", and "phone2", and paste it as a continuos line (no spaces)
into the field in the web page I need to use.

I know that this one is a pretty "tall order," if it were easy I
probably could figure it out on my own, or maybe I am just giving
myself too much credit.

Thank you very much to whomever may help; this will help save me hours
of work, and my company the cost of those hours of work.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top