Home |
Search |
Today's Posts |
#1
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
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Mail Merge: Label Wizard in in Excel | Excel Discussion (Misc queries) | |||
Mail Merge Label Problem | Excel Discussion (Misc queries) | |||
label mail merge | Excel Discussion (Misc queries) | |||
How can I do a mail merge for printing label from an excel spread | Excel Discussion (Misc queries) | |||
How to print priority mail label in excel | Excel Discussion (Misc queries) |