Thread: Mail merge with filter using data inputted by user
View Single Post
 
Old 04-07-2013, 04:58 PM
macropod's Avatar
macropod macropod is offline Windows 7 64bit Office 2010 32bit
Administrator
  
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,521
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
Hi Tornado70,


Assuming you only want the output to reflect a nominated shift on a nominated dat, you could use a SKIPIF field, coded along the lines of:
{SKIPIF{={IF{MERGEFIELD MyDate \@ YYYYMMDD}={FILLIN "Date to include (in YYYYMMDD format, please)." \@ YYYYMMDD \o } 1 0}*{IF{MERGEFIELD Shift}={FILLIN "Shift to include." \o} 1 0}}= 0}

Note: The field brace pairs (ie '{ }') for the above example are created in the body of the document via Ctrl-F9 (Cmd-F9 on a Mac) - you can't simply type them or copy & paste them from this message.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote