View Single Post
 
Old 10-05-2016, 10:45 AM
rcfretwell rcfretwell is offline Windows 8 Office 2003
Novice
 
Join Date: Oct 2016
Posts: 1
rcfretwell is on a distinguished road
Default Mail merge using fields and headers if then

Can anyone tell me how to do a mail merge for labels using a list of items below with descriptions and sizes. This is clothing information and we need to run labels for the entire database, but only for the items having quantities under the sizes (i.e ALG Adult Large quantity of 21). We would need the merge to create (using line one as an example) three labels with the description and each having the the appropriate size associated with the label, which are headers in the database (ALG, AXL and A2X). We've tried the IF Then function, but cannot get the formula to work properly. Any help would be appreciated. This may have already been addressed, but we did not locate it in the forum.

Description No Size YXS YS YM YL AXS ASM AMD ALG AXL A2X
Tee - Green - Next Level 21 9 16
Tee - Ash Gray - Next Level 1 3
Tee - Royal Blue - Next Level 3 12
Reply With Quote