Microsoft Office Forums

Go Back   Microsoft Office Forums > Microsoft Word > Mail Merge

Reply
 
LinkBack Thread Tools Display Modes
  #1  
Old 10-18-2017, 10:13 AM
rschnell rschnell is offline Mac OS X Office 2016 for Mac
Novice
 
Join Date: Oct 2017
Posts: 2
rschnell is on a distinguished road
Default [Word 2016 for Mac] SKIPIF condition doesn't work

Hi everybody



Unfortunately I can't solve my merge letter problem and I have tried everything to solve it. For a better explanation I've made some screenshots of the spreadsheet and Word file. See attached

In the spreadsheet I have several customers who have different campaigns. Now I want to print in Word per employer the different campaigns on one site.

Now I tried to merge the data but I get only 6 pages from the employers which I marked green in the first picture. The other employers (it should be 12 pages) do not appear and I don't know why. Does anybody know why?

Thanks for your help!
Attached Images
File Type: png 427b67-1508336704.png (123.5 KB, 3 views)
File Type: png 7c42ab-1508336923.png (73.4 KB, 3 views)

Last edited by macropod; 10-18-2017 at 01:02 PM. Reason: Attached sceenshots locally.
Reply With Quote
  #2  
Old 10-18-2017, 01:10 PM
macropod's Avatar
macropod macropod is offline Windows 7 64bit Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 19,468
macropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to behold
Default

Your current approach won't work. Instead you could use Word's Catalogue/Directory Mailmerge facility (the terminology depends on the Word version). To see how to do so with any mailmerge data source supported by Word, check out my Microsoft Word Catalogue/Directory Mailmerge Tutorial at:
http://windowssecrets.com/forums/sho...merge-Tutorial
or:
http://www.gmayor.com/Zips/Catalogue%20Mailmerge.zip
The tutorial covers everything from list creation to the insertion & calculation of values in multi-record tables in letters. Do read the tutorial before trying to use the mailmerge document included with it.

Depending on what you're trying to achieve, the field coding for this can be complex. However, since the tutorial document includes working field codes for all of its examples, most of the hard work has already been done for you - you should be able to do little more than copy/paste the relevant field codes into your own mailmerge main document, substitute/insert your own field names and adjust the formatting to get the results you desire. For some worked examples, see the attachments to the posts at:
http://www.msofficeforums.com/mail-m...html#post23345
http://www.msofficeforums.com/mail-m...html#post30327
http://windowssecrets.com/forums/sho...l=1#post928391

Another option would be to use a DATABASE field in a normal ‘letter’ mailmerge main document, with a workbook that contains a single instance of each of your employer names and IDs on one worksheet - which is used for the mailmerge data source - and your existing worksheet which is referenced by a DATABASE field. Or you could keep your existing workbook setup and use both a DATABASE field and a macro to drive the process. An example of this approach can be found at: http://answers.microsoft.com/en-us/o...1-1996c14dca5d
The DATABASE field can even be used without recourse to a mailmerge. An example of such usage can be found at: http://www.msofficeforums.com/mail-m...html#post67097

Alternatively, you may want to try one of the Many-to-One Mail Merge add-ins, from:
Graham Mayor at http://www.gmayor.com/ManyToOne.htm; or
Doug Robbins at http://bit.ly/1hduSCB
__________________
Cheers,
Paul Edstein
[MS MVP - Word]
Reply With Quote
  #3  
Old 10-19-2017, 08:14 AM
rschnell rschnell is offline Mac OS X Office 2016 for Mac
Novice
 
Join Date: Oct 2017
Posts: 2
rschnell is on a distinguished road
Default

Thanks Paul for your help! It works pretty good! The only problem I have is to format my output (see attachment).

If I have an employer with more than one campaign, Word splits the tables. Is there an option where I can put the tables one after the other without a gap?

My second problem is how to make a total amount of all campaigns at the end of the last table?

Thanks for your help!
Attached Images
File Type: png T1.png (58.9 KB, 3 views)
File Type: png T2.png (29.7 KB, 3 views)
Reply With Quote
  #4  
Old 10-19-2017, 02:01 PM
macropod's Avatar
macropod macropod is offline Windows 7 64bit Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 19,468
macropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to behold
Default

That behaviour is documented in the tutorial. which includes a macro for cleaning up the output. The tutorial also tells you how to have the merge tally the amounts.
__________________
Cheers,
Paul Edstein
[MS MVP - Word]
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Word 2016 cannot hide field codes in document created by work 2013 twinclouds Word 2 03-10-2017 03:15 PM
Slicer built in 2016 doesn't work in 2013 cdoody Excel 0 10-31-2016 10:25 AM
Word 2016 (Windows) How Does Banding Work? jthomas666 Word Tables 3 06-06-2016 06:27 AM
Word vs Excel (NEXTIF, SKIPIF mergefield) jerry00769 Mail Merge 3 04-30-2012 03:43 PM
Word 2007 Font Color Doesn't Work nnicko Word 2 04-16-2010 01:21 PM


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


Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.
MSOfficeForums.com is not affiliated with Microsoft