Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Group items in same account on same letter.
Serial Model Account Number Customer PostCode
1234 Widget A1 AC001 Banana plc B1 2QH 1235 Widget A2 AC001 Banana plc B1 2QH 1236 Widget A3 AC002 Orange plc D32 2DU 1237 Widget A4 AC003 Plum plc H62 2JU 1238 Widget A5 AC003 Plum plc B65 3KI 1239 Widget A6 AC005 Apricot plc J89 3WJ 1240 Widget A7 AC006 Melon plc K89 3JI 1241 Widget A8 AC006 Melon plc K89 3JI 1242 Widget A9 AC007 Lemon plc G67 2JI We have the above data, in an excel sheet. We need to produce seperate sheets from the list for each Customer Location (i.e where account number & postcode are the same) I.e this would produce 7 seperate pages as follows. As the mergedata file in sorted by account number then postcode, related items are together. What is the easiest way to acheive this in Word? ------------------------- AC001 Banana plc B1 2QH 1234 Widget A1 1235 Widget A2 -------------------------- AC002 Orange plc D32 2DU 1236 Widget A3 ------------------------- AC003 Plum plc H62 2JU 1237 Widget A4 -------------------- AC003 Plum plc B65 3KI 1238 Widget A5 --------------------- AC005 Apricot plc J89 3WJ 1239 Widget A6 -------------------- AC006 Melon plc K8 3JI 1241 Widget A7 1242 Widget A8 ------------------------- AC007 Lemon Plc G67 2JI 1241 Widget A9 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to make one large letter per 81/2x11 page top to bottom? | Page Layout | |||
Insert certain paragraphs based on fields in Excel database | Mailmerge | |||
letter regarding outstanding layby account | Microsoft Word Help | |||
Convert to Symbols | Microsoft Word Help | |||
Can't save merged form letter... | Mailmerge |