I would first like to thank you for responding to my post. I am not a
very skilled user when it comes to macros, actually they are new to me,
so I was just wondering if you could give me a little more detail. I
haven't been able to attempt the directions you gave me because my
computer with excel on it is currently down. One thing I was uncertain
about is, how would I go about adding the phone numbers in once I am at
the correct URL, is there a way I can add that cell without having to
actually add the phone number into the URL search box. One other
question, how and where would I create the for/each loop so that the
steps will be followed for all the list of phone numbers, Thus saving
me from searching each phone number one by one through the internet.

Don Guillett wrote:
You can goto the correct url and get the info on the screenthen right click
in the tableimport to microsoft exceldataimport external dataedit
queryget the tablesrecord a macro put into a for/each loop.

--
Don Guillett
SalesAid Software