How to make a address label ?

E

eeeeguan

Can someone help me to make address label where my excel spreed sheet is like
this :

No Name ID Email Phone1 Phone2 address1 address2 address3

i want it to be display in word or excel as at below :


NO NAME ID NO NAME ID NO
NAME ID
ADDRESS1 ADDRESS1
ADDRESS1
ADDRESS2 ADDRESS2
ADDRESS2
ADDRESS3 ADDRESS3
ADDRESS3
EMAIL EMAIL
EMAIL
PHONE1 PHONE1
PHONE1
PHONE2 PHONE2
PHONE2
 
D

David Biddulph

The best way is to use MS Word's mail merge facility, and tell it to use
your Excel file as the source data. Word help will tell you how.
 

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

how can i make address label ...pls help 1
how to convert my excel data to word label 2
Help.... on mail label 1
How to create address lable from excel data 1
Joining VLookups with line breaks but ignoring blanks 3
Split single cell data into multiple colums 3
Looking up data within a collumn 3
Mailing address block: sorting 1 row to columns 1

Top