excel as address book

[Guest]

if I have used a excel sheet for an address book, Name, address, address1,
etc etc in the columns and the individual address' in the rows, is there any
way I can convert that to a list of all the different address' individually
???

 

[David McRitchie]

Hi Pete,
I your intent is to print labels, you would use Microsoft Word with your
Excel sheet as the first sheet and used as the database.
http://www.mvps.org/dmcritchie/excel/mailmerg.htm

 

[Gord Dibben]

Pete

Sounds like each row is a separate person and address etc. but not sure.

That is the normal format if you are exporting to an address book or using in
a MailMerge with Word or similar.

What exactly do you want done with the list you now have?

Show us a small example, maybe 5 or 6 rows of data so's we can get a better
idea.


Gord Dibben Excel MVP

 

[Guest]

Say I Have:

Name Address Address 1 Tel email
Peter 1 ding Place LA 3184748
pete@ding
George 17 My Road NYC 4756474
George@My

Can I get them to automatically go onto a page as follows, wihtout having to
type them all out again??:

Peter
1 ding place
LA
3184748
pete @ ding


George
17 My Road etc etc etc

 

[David McRitchie]

yes, see my previous answer using Mail Merge, if you don't have Word
you can use the elephants are us example of John Walkenbach's in the
related area, but Mail Merge is best.