Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 02-26-2018, 03:31 PM
takamaz takamaz is offline Mailmerge, show region only the first time. Mac OS X Mailmerge, show region only the first time. Office 2016 for Mac
Novice
Mailmerge, show region only the first time.
 
Join Date: Feb 2018
Posts: 8
takamaz is on a distinguished road
Default Mailmerge, show region only the first time.

I'm guessing this is probably in one of the guides somewhere, but after two days of tearing my hair our and getting almost everything else to work, I've gotten to a point in my directory where I just need to get the Region to only show the first time it occurs.

My Merge looks like this

Screenshot 2018-02-26 14.26.58.png

and produces this:

Screenshot 2018-02-26 14.26.38.png

I want to eliminate the "North"s, "east"s and "West"s, except for the first occurrence of each. I worked with the Catalogue Mailmerge Tutorial quite a bit, and was never able to achieve that result.



Thanks for any help - this whole process has made me feel pretty dumb.
Reply With Quote
  #2  
Old 02-26-2018, 04:41 PM
macropod's Avatar
macropod macropod is offline Mailmerge, show region only the first time. Windows 7 64bit Mailmerge, show region only the first time. Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

You might want to check out the Merge Records By Category Using Two Keys implementation in my Microsoft Word Catalogue/Directory Mailmerge Tutorial:
https://www.msofficeforums.com/word/...-tutorial.html
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.

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.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #3  
Old 02-26-2018, 05:01 PM
takamaz takamaz is offline Mailmerge, show region only the first time. Mac OS X Mailmerge, show region only the first time. Office 2016 for Mac
Novice
Mailmerge, show region only the first time.
 
Join Date: Feb 2018
Posts: 8
takamaz is on a distinguished road
Default

I've spent a lot of time working from that tutorial and was getting the same output, with less formatting control than I've got now. I see something now that I will try again later with that, but even working with a directly copy/pasted code, mine did not produce results identical to what is in the tutorial, and one of the Keys was always repeated for every iteration.

One thing I have not been able to figure out in the tutorial for two keys is what specifically the "Quote" field does and is for?
Reply With Quote
  #4  
Old 02-26-2018, 05:13 PM
macropod's Avatar
macropod macropod is offline Mailmerge, show region only the first time. Windows 7 64bit Mailmerge, show region only the first time. Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

Correctly implemented, you'd get:

North

Reggie Mantle
A971 etc.
B971, etc.
R971, etc.

Betty Cooper
C971, etc.
C971, etc.

East

Archie Andrews
D971, etc.
E971, etc.
A971, etc.

Jugghead Jones
F971, etc.
J971, etc.
A971, etc.

and so on, as demonstrated in the tutorial.

The encompassing QUOTE field merely ties the whole construction together, which makes it easier to copy/paste and ensures all the related fields update together.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Mailmerge, show region only the first time. Plotting a graph to show individual SKU sales over time JumpInTheFire83 Excel 1 12-07-2015 01:57 PM
Run Time Error '91': Object variable or With block variable not set using Catalogue Mailmerge Berryblue Mail Merge 1 11-13-2014 05:36 PM
Mailmerge, show region only the first time. MailMerge - Time showing 12:30 instead of 0:30 Chris424 Mail Merge 2 11-17-2011 05:51 AM
Mailmerge, show region only the first time. Show only vacation/time off in shared calendar? famlit Outlook 1 03-29-2011 02:58 AM
Saving as PDF causes prompt for printable region out of range chrisxyz Word 0 02-22-2010 05:58 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 03:03 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