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.
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.