ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How to make a address label ? (https://www.excelbanter.com/excel-discussion-misc-queries/245493-how-make-address-label.html)

eeeeguan

How to make a address label ?
 
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






David Biddulph[_2_]

How to make a address label ?
 
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.
--
David Biddulph

"eeeeguan" wrote in message
...
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









All times are GMT +1. The time now is 06:06 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com