What is the best way to organize a mailing list that I purchased .

M

mjmatthe

I purchased a direct mail list from citydirectory.com. I have saved it in
Excel 2000. I had ordered all possible contacts for each address and what I
received has each person on their own row, even if they have the same
address. For example, Ray Peterson of 108 Oak Street is on Row#9 and Jane
Peterson of 108 Oak Street is on Row#10, but I want to address the form
letter to Ray and Jane Peterson. What I am looking for is the most efficient
method to combine names of the same address onto only one row. Is it even
plausible that I don't have to just cut and paste and delete to consolidate
the residents of the same address onto one entry? I appreciate any help or
direction anyone can offer. Thank you!
 
B

Bob I

Atempting this "progamatically" will result in a variety of interesting
name combinations. The fastest would be to DELETE duplicate addresses,
the slowest and most accurate would be to do it "by hand".
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

What's the best way to convert a contact list to mailing labels? 2
Mass mailing from list typed in Word document 1
Print envelopes for mass mailing from list of addresses in word do 5
Organizing list of contacts in .xlsx 1
Trying to create a mailing list using a combination of data and anaddress list. 2
Rules and Reply-to E-Mail addresses 1
Formula or code for address list into mailing format? 2
What's the best way to keep a large list of addresses? 2

Top