Hello. Word 2007.
I wonder if someone can point me to a list of names and addresses, etc., that I might use to demonstrate mail-merging?
My googling is failing at the mo.. Andy.
List of names and addresses
-
- SilverLounger
- Posts: 2403
- Joined: 05 Feb 2010, 22:21
- Location: London ENGLAND
List of names and addresses
"I'm here to save your life. But if I'm going to do that, I'll need total uninanonynymity." Me Myself & Irene.
-
- GoldLounger
- Posts: 2599
- Joined: 24 Jan 2010, 15:26
- Location: Olympia, WA
Re: List of names and addresses
Why not just make up your own list.
I am so far behind, I think I am First
Genealogy....confusing the dead and annoying the living
Genealogy....confusing the dead and annoying the living
-
- SilverLounger
- Posts: 2403
- Joined: 05 Feb 2010, 22:21
- Location: London ENGLAND
Re: List of names and addresses
Hi. I generally do, but I tend to run out of inspiration after about 10 rows. I should spend some time when I get a chance trying to track down a list.DaveA wrote:Why not just make up your own list.
I really want a sizeable list of UK names and addresses. Apparently this should be fairly easy to obtain, according to all the junk mail one receives
"I'm here to save your life. But if I'm going to do that, I'll need total uninanonynymity." Me Myself & Irene.
-
- GoldLounger
- Posts: 2599
- Joined: 24 Jan 2010, 15:26
- Location: Olympia, WA
Re: List of names and addresses
Yes, you are so right, but the problem I see is the different addressing for the different areas of the world. I know that a list for the US would not be a lot use to those in England .
I am so far behind, I think I am First
Genealogy....confusing the dead and annoying the living
Genealogy....confusing the dead and annoying the living
-
- SilverLounger
- Posts: 2403
- Joined: 05 Feb 2010, 22:21
- Location: London ENGLAND
Re: List of names and addresses
I'm attempting to download a million sample UK (fake) names, addresses and DOBs etc from http://www.grid-tools.com/resources/free_test_data.php. They have a US list as well.
It will take quite a while with my broadband dongle! And these data-generators are not always that great as they sometimes prove repetitive, un-realistic. Actually, it's a zip file but I did specify Access as my database, so hopefully I'm not wasting my time.
It's possible to obtain a list (28 million!) from the Post Office.. for a few hundred quid (It's called a PAF.)
I don't really need a million either; 50 or 100 would have been fine . Still, it will be useful to me in Access as well.
I'll report back tomorrow. Andy.
Added: Just noticed an irritation: "A representative will be in touch with you shortly" - great!
It will take quite a while with my broadband dongle! And these data-generators are not always that great as they sometimes prove repetitive, un-realistic. Actually, it's a zip file but I did specify Access as my database, so hopefully I'm not wasting my time.
It's possible to obtain a list (28 million!) from the Post Office.. for a few hundred quid (It's called a PAF.)
I don't really need a million either; 50 or 100 would have been fine . Still, it will be useful to me in Access as well.
I'll report back tomorrow. Andy.
Added: Just noticed an irritation: "A representative will be in touch with you shortly" - great!
"I'm here to save your life. But if I'm going to do that, I'll need total uninanonynymity." Me Myself & Irene.
-
- 4StarLounger
- Posts: 504
- Joined: 23 Jul 2010, 18:36
- Location: Westlake, OHIO
Re: List of names and addresses
How about writing a script to create the data since it does not have to be correct. i.e. the end results would like like:
Martha Smith, 1520 Lincoln Road, Cheshire, UK
Martha Smiti, 1521 Lincoln Road, Cheshire, UK
etc. Change 1 letter and one number. This script could create a file with as many as you want.
Martha Smith, 1520 Lincoln Road, Cheshire, UK
Martha Smiti, 1521 Lincoln Road, Cheshire, UK
etc. Change 1 letter and one number. This script could create a file with as many as you want.
Who will you Inspire today?
-
- SilverLounger
- Posts: 2403
- Joined: 05 Feb 2010, 22:21
- Location: London ENGLAND
Re: List of names and addresses
Hi Timelord.
I could do that in Excel by filling-down as well, but it wouldn't give the range of 'semi-realistic' data I'm after.
It's not a major issue though, so perhaps I'll see how this download works out.
Ta, Andy.
I could do that in Excel by filling-down as well, but it wouldn't give the range of 'semi-realistic' data I'm after.
It's not a major issue though, so perhaps I'll see how this download works out.
Ta, Andy.
"I'm here to save your life. But if I'm going to do that, I'll need total uninanonynymity." Me Myself & Irene.
-
- SilverLounger
- Posts: 2403
- Joined: 05 Feb 2010, 22:21
- Location: London ENGLAND
Re: List of names and addresses
Hi. Vista can't open this .zip file. I thought it might be an Access or .csv file so changed the file extension but it's not one of these (.mdb, .accdb or .csv).
Is there a (free) application that would determine what kind of file it is?
If not, I might just delete it and not worry about it. Andy.
Is there a (free) application that would determine what kind of file it is?
If not, I might just delete it and not worry about it. Andy.
"I'm here to save your life. But if I'm going to do that, I'll need total uninanonynymity." Me Myself & Irene.
-
- Administrator
- Posts: 78647
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: List of names and addresses
If you have a hex editor, you could look at the first few bytes of the file, they often provide information about the file type...
Best wishes,
Hans
Hans
-
- SilverLounger
- Posts: 2403
- Joined: 05 Feb 2010, 22:21
- Location: London ENGLAND
Re: List of names and addresses
Ach, I'll nay bother! Perhaps I'll revise my searching to look for a sample (UK) contacts database, or just spend a dull afternoon making up about 50 names/addresses.HansV wrote:If you have a hex editor, you could look at the first few bytes of the file, they often provide information about the file type...
It's not a concern. Regards, Andy.
"I'm here to save your life. But if I'm going to do that, I'll need total uninanonynymity." Me Myself & Irene.
-
- Administrator
- Posts: 78647
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: List of names and addresses
Don't you have 50 monkeys and 50 typewriters? If they don't produce the complete works of Shakespeare, they might produce a suitable address list...
(They can take pictures too...)
(They can take pictures too...)
Best wishes,
Hans
Hans