View Single Post
 
Old 08-04-2010, 05:21 PM
trims30 trims30 is offline Windows 7 Office 2007
Novice
 
Join Date: Aug 2010
Posts: 1
trims30 is on a distinguished road
Default MailMerge Labels Question

I have data in the following tab delimited format that I wish to print on Avery 5160 Label sheets.

A-100 Wheel Bearing Acme Sales Co. 102905
A-100 Wheel Bearing Timken Manufacturing 40349-A
A-100 Wheel Bearing NAPA Auto Parts NA-102905
CG-204 Cam Drive Gear Wilson Gear Co WG-2104
CG-204 Cam Drive Gear Cleary Cam Supply B-1908998

Resulting labels should look like:

A-100 Wheel Bearing
Acme Sales Co. 102905
Timken Manufacturing 40349-A
NAPA Auto Parts NA-102905
---------------------------------------------
CG-204 Cam Drive Gear
Wilson Gear Co WG-2104
Cleary Cam Supply B-1908998

---------------------------------------------

How do I set this up in Word Mail Merge?
Need to drop 1st 2 fields if they've been printed already.
Need to break to next label if 1st field in record is different than 1st field in previous record.

Any help is appreciated.

Lee
Reply With Quote