excel as address book

P

Pete

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
???
 
G

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
 
P

pete

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
 
D

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.
 
Top