Hi Todd,
Why are you asking us if it is your program he is going to feed.
Otherwise, hopefully there is flexibility in your program.

As far as a visual presentation goes I would put whatever is
sorted in column B, and the phone number contact in column A
as it is the phone number you would want quickest access to if
looking at a list.

If there are separate addresses, I would include all information
and not leave out company name etc when you have multiple
addresses for the same company -- makes working with
Excel and sorting a lot easier, as well as printing address labels
with mail merge. If you have multiple addresses or contacts
you might use a column to indicate primary as 1 so that you
can filter on the list as to who gets a mailing.

They can prepare their list in any order that is easy to prepare
initially and then move columns around for future use as
name and address list.
http://www.mvps.org/dmcritchie/excel/fillhand.htm#mouse
see " Move a Column(s) and insert between columns
without losing data" below that topic.

---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

wrote in message oups.com...
I have a customer that wants compile his own mailing list. Since he has
excel and my mailing software imports excel files, it seems like I
should have him put his list together in excel.

Is the best way to to this to designate column A as say business name,
column B as first name, column C as last name, column D as address and
so on and so forth. All columns would be kept consistant with their
designations and each number line would be a seperate address. Would
this be the proper way to have him set up his mailing list????

Please help!

Thanks,
Todd