Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 10-05-2016, 10:45 AM
rcfretwell rcfretwell is offline Mail merge using fields and headers if then Windows 8 Mail merge using fields and headers if then Office 2003
Novice
Mail merge using fields and headers if then
 
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
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Mail merge using fields and headers if then Excel / Mail Merge - Return Column Headers for All and Any Columns with Values eduams Mail Merge 1 09-26-2016 07:02 PM
Mail merge using fields and headers if then Mail Merge fields merge incorrectly and won't fix. marym Mail Merge 3 04-09-2016 05:17 AM
insert fields mail merge in vba tariqaleed2 Word VBA 6 08-21-2014 12:21 AM
Mail merge using fields and headers if then Mail Merge only produces 15 fields fm 22 Galceran Mail Merge 2 02-10-2013 05:47 PM
Mail merge using fields and headers if then Conditional merge fields in mail merge Aude Mail Merge 1 01-06-2012 07:38 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 09:15 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft