[mso] Re: C & P'ing names and address into Excel from websites-
- From: "Ken \(desco\) Ramsey" <desco1kr@xxxxxxxxxxxxxxxx>
- To: <mso@xxxxxxxxxxxxx>
- Date: Fri, 26 May 2006 20:05:08 -0400
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).
//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).
//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: