|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
October 15th, 2009, 04:57 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
Help.... on mail label
Can someone show me how to make label where my data in excel look like
NO NAME ID PHONE1 PHONE2 EMAIL ADDRESS1 ADDRESS2 ADDRESS3 1. xxxx aa 111111 123456 xx@xxx 1xxxxxxx xxxxxxx xxxxxxxx 2. xxxx aa 121231 123455 xx@xxx wwwww qqqqqq sssssss 3. x1x2 ab 122334 123455 xy@mm nnnnnnn sdsdsd sdedede 4. xzxzx ac 98989 987789 ty@mm xcxcxccc xcxcxcx xcfxcfxcf What should in do ? if i want the result in word or excel to be like : 1. xxxxx aa 2. xxxxx aa 3. xzxzx ac 1xxxxxxxx wwwww nnnnnnn xxxxxxxxxxxx qqqqqq sdsdsd xx@xxx xx@xxx xy@mm 111111 121231 122334 123456 123455 123455 4. xzxzx ac 5. 6. xcxcxccc xcxcxcx xcfxcfxcf ty@mm 98989 987789 How someone can kindly help me for the following label. No formating needed. Just need simple lable. Data in excel spredsheet.Thanks 
|
|
#2
October 15th, 2009, 05:38 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
Help.... on mail label
Try Google Mail Merge in Excel.
Here's a site with a step by step guide (look in left column for what you want): http://www.functionx.com/mailmerge/excel.htm "yeeguan" wrote: Can someone show me how to make label where my data in excel look like NO NAME ID PHONE1 PHONE2 EMAIL ADDRESS1 ADDRESS2 ADDRESS3 1. xxxx aa 111111 123456 xx@xxx 1xxxxxxx xxxxxxx xxxxxxxx 2. xxxx aa 121231 123455 xx@xxx wwwww qqqqqq sssssss 3. x1x2 ab 122334 123455 xy@mm nnnnnnn sdsdsd sdedede 4. xzxzx ac 98989 987789 ty@mm xcxcxccc xcxcxcx xcfxcfxcf What should in do ? if i want the result in word or excel to be like : 1. xxxxx aa 2. xxxxx aa 3. xzxzx ac 1xxxxxxxx wwwww nnnnnnn xxxxxxxxxxxx qqqqqq sdsdsd xx@xxx xx@xxx xy@mm 111111 121231 122334 123456 123455 123455 4. xzxzx ac 5. 6. xcxcxccc xcxcxcx xcfxcfxcf ty@mm 98989 987789 How someone can kindly help me for the following label. No formating needed. Just need simple lable. Data in excel spredsheet.Thanks
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
