Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 12-27-2013, 03:04 AM
macropod's Avatar
macropod macropod is offline Right Justify Values in a Mail Merge Windows 7 32bit Right Justify Values in a Mail Merge Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,514
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

The issue with the double quotes relates to the construction of the IF test. Essentially, if any part of the expression contains more than one field or word, that part of the expression needs to be enclosed in double quotes.

As for documentation, there is some available via the Insert|Quick Parts|Field dialogue, and some more at:


http://office.microsoft.com/en-us/wo...102110133.aspx?
http://office.microsoft.com/en-us/wo...101830917.aspx
If you want to learn more of what you can do with fields, check out the 'Sticky' threads (all of which I authored) at:
http://windowssecrets.com/forums/for...ord-Processing
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #2  
Old 12-29-2013, 01:37 PM
hadenp hadenp is offline Right Justify Values in a Mail Merge Windows XP Right Justify Values in a Mail Merge Office 2010 32bit
Novice
Right Justify Values in a Mail Merge
 
Join Date: Dec 2013
Posts: 4
hadenp is on a distinguished road
Default

Thanks Paul. Would you be able to explicate how quotes are paired in a code example from the Mailmerge Tutorial for us ?

In the first example, "Merge Records by Category",

{QUOTE{IF {MERGESEQ} =1 {SET KEY ""}}"{IF{MERGEFIELD City}<> {REF Key}
"IF...

is the quote (in red) the beginning of a new expression? And does that expression end with the next quote before IF - or is it paired with another quote further down?

Also, the use of QUOTE..I think it's used here to return values after expressions are evaluated. Is that correct?

Thanks!
Reply With Quote
Reply

Tags
field code, justification, tabs



Similar Threads
Thread Thread Starter Forum Replies Last Post
Loss of formulae values when mail merging excel to word MellowMel Mail Merge 6 05-09-2014 09:08 AM
Prevent Zero Values being Suppressed in a Mail Merge HangMan Mail Merge 2 12-11-2013 02:28 PM
Right Justify Values in a Mail Merge Content control merge values? skrallemand Word VBA 8 10-02-2013 06:54 AM
Mail Merge Duplication of address on merge RICKY Mail Merge 1 09-26-2012 03:14 PM
Right Justify Values in a Mail Merge 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 05:00 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