Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #6  
Old 07-23-2015, 10:45 PM
DBlomgren DBlomgren is offline Mail Merge - generating multiple letters Windows 8 Mail Merge - generating multiple letters Office 2013
Advanced Beginner
 
Join Date: Feb 2014
Location: New York, USA
Posts: 82
DBlomgren is on a distinguished road
Default

Thanks for the clarification. With that little peek into your world, I wonder if you could combine some of these or even all the D letters, but let's start small.

I imagine that R17 says something like
"we are sending you a check for (check_amt) and a credit of (credit_amt) and R18 says something like
"we are offering you a credit for (credit_amt)".

One way to make these one letter is to have something like (my syntax isn't perfect but it can get you started):
"we are sending you a check for (check_amt)
<if not blank> and a credit of (credit_amt)<end if>.

If you're not familiar with if statements, I recommend starting small by combining two letters. That would get you down to 15 to 20 letters and cut your work in half.
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Mail Merge - generating multiple letters Multiple mail merge PKAYHORM Mail Merge 1 09-29-2013 07:45 PM
Mail merge with a hyperlink for multiple recipient with different url's? prkk.06 Mail Merge 6 05-01-2013 06:42 AM
Mail Merge - generating multiple letters Mail Merge multiple rows? ender541 Mail Merge 1 08-21-2012 03:14 PM
Mail Merge - generating multiple letters Multiple Mail Merge? imogul Mail Merge 1 06-24-2011 07:20 PM
Mail Merge - generating multiple letters Generating multiple documents from 1 data source themangoagent Word 2 08-14-2009 12:12 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 06:23 PM.


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