[mso] Re: C & P'ing names and address into Excel from websites-

Paste to emailStripper, available for free from
http://www.papercut.biz/emailStripper.htm
Removes frames, links formatting, soft carriage returns, etc.

-----Original Message-----
From: mso-bounce@xxxxxxxxxxxxx [mailto:mso-bounce@xxxxxxxxxxxxx]On Behalf Of
Robert Carneal
Sent: Friday, May 26, 2006 3:18 PM
To: mso@xxxxxxxxxxxxx
Subject: [mso] C & P'ing names and address into Excel from websites-

Hello everyone. I am hoping someone can offer some advice.

I am trying to locate address of descendent of my ancestors. That is, people
like my gggg-grandfather's children, their children, and the children's
children and so on.

There are sites that will have names and addresses, but often are chock full
of other stuff such as buttons.

Suppose a find a list of names that I believe I might have some luck with by
snail writing to them. I would like to capture / copy the name, address, and
phone number, and paste it in Excel, and build a list of people with a high
probability of being related to me.

A list such as:

John Doe                        Mark Smith                      Jane Brown
123 Walnut                      1234 Apricot Way                65 Maple
Avenue
Indianapolis, IN 12345  New York, NY 22222      Miami, FL 57483
123-456-7890                    333-444-5555                    666-666-6666

Kathy Bowman            James Brown                     William Brown
333 Apple Way           444 Banana Ave          55 Coconut Drive
St. Minrad, IN 33333            St Jose, TX 77222               Oklahoma
Cty, OK 44444
343-434-3434                    222-222-2222                    999-999-9999


Ok, my thinking was if it is already in a table of some kind, it would copy
and paste into Excel fairly well. It often does not. "65 Maple Avenue" (Jane
Brown's address in the right hand column) might paste into column CR (yes,
*70* columns away from the left instead of just the third column!), whereas
Kathy Bowman's phone number might get pasted in Row 358.   In short, it is
being pasted ostensibly at random cells instead of some kind of order.  And,
if a person's phone number is not listed, then the next person's name is put
in the wrong cell, making the name and address off. If it would paste into
Excel in some kind of reliable order, I can work with it.

However, when I paste the above into a table is frequently disorganized. It
might look like this (Exaggeration):
John    Doe             Mark    Smith           Jane    Brown
123     Walnut          1234    Apricot Way     65      Maple   Avenue
Indianapolis,   IN      12345   New     York,   NY      22222   Miami,  FL
57483
123-456-7890            333-444-5555            666-666-6666
                        Brown
Kathy   Bowman  James
William Brown
333     Apple   Way     444     Banana  Ave     55      Coconut Drive
St.     Minrad, IN      33333   St      Jose,   TX      77222   Oklahoma
Cty,    OK      44444
343-434-3434            222-222-2222            999-999-9999

That is not of much use to me. <g>

My question: Does anyone know how to capture names and address on a website
and paste it into Excel? This is not for a mass mailing list, I will contact
them one at a time, person to person via snail mail. Any ideas? Suggestions?
I tried SnagIt, which was advertised to capture text and save as text in CVS
format, but the trial version didn't do that. I tried something called
"SelectiveCapture" (which is supposed to let you define what you want from a
web page, and I said name, address, town, state, zip, phone), but what it
did was do that, and go on to get information from web sites I do not want
information from. (too much information, in other words. Billy Joe-Bob
MacKenzie might be a business partner of my ancestor, but I am not looking
for him simply because my ancestor's name was hyper linked to Billy Joe-Bob,
just the information on the web page I see. I hope I am making sense. If I
am not making sense- write me and I will give some more examples.

If someone suggests a product to try, I will happily try it. I have a lot of
names I want to capture.

Thank you.

Robert

*************************************************************
You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or
MicrosoftOffice@xxxxxxxxxxxxxxxx

To send mail to the group, simply address it to mso@xxxxxxxxxxxxx

To Unsubscribe from this group, visit the group's homepage and use the
dropdown menu at the top.  This will allow you to unsubscribe your email
address or change your email settings to digest or vacation (no mail).
http://www.freelists.org/webpage/mso

To be able to use the files section for sharing files with the group, send a
request to mso-moderators@xxxxxxxxxxxxx and you will be sent an invitation
with instructions.  Once you are a member of the files group, you can go
here to upload/download files:
http://www.smartgroups.com/vault/msofiles

If you are using Outlook and you see a lot of unnecessary code in your email
messages, read these instructions that explain why and how to fix it:
http://personal-computer-tutor.com/abc3/v28/greg28.htm
*************************************************************

*************************************************************
You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or 
MicrosoftOffice@xxxxxxxxxxxxxxxx

To send mail to the group, simply address it to mso@xxxxxxxxxxxxx

To Unsubscribe from this group, visit the group's homepage and use the dropdown 
menu at the top.  This will allow you to unsubscribe your email address or 
change your email settings to digest or vacation (no mail).
http://www.freelists.org/webpage/mso

To be able to use the files section for sharing files with the group, send a 
request to mso-moderators@xxxxxxxxxxxxx and you will be sent an invitation with 
instructions.  Once you are a member of the files group, you can go here to 
upload/download files:
http://www.smartgroups.com/vault/msofiles

If you are using Outlook and you see a lot of unnecessary code in your email 
messages, read these instructions that explain why and how to fix it:
http://personal-computer-tutor.com/abc3/v28/greg28.htm
*************************************************************

Other related posts: