Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 03-07-2013, 12:27 PM
kevinatshale kevinatshale is offline Mail Merge If statement Windows 8 Mail Merge If statement Office 2010 64bit
Novice
Mail Merge If statement
 
Join Date: Mar 2013
Posts: 1
kevinatshale is on a distinguished road
Default Mail Merge If statement

Hello,

I'm trying to do a mail merge and I want to use an If statement.

We have a signature page that sometimes needs to be signed by more than one party.

Is there a way to create an If statement that has the variable of "if more than person, create another signature line for the extra person"



Thanks hope this is explained enough
Reply With Quote
  #2  
Old 03-07-2013, 04:36 PM
macropod's Avatar
macropod macropod is offline Mail Merge If statement Windows 7 64bit Mail Merge If statement Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,963
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 simple answer is yes, but you'd need to have something in the datasource the field can evaluate. For example:
{IF«Sig_Count»= 2 "__________________¶
__________________¶
"
"__________________¶
"}
where 'Sig_Count' is a field in the data source indicating the # signatures required.

Note: The field brace pairs (i.e. '{ }') for the above example are all created in the document itself, via Ctrl-F9 (Cmd-F9 on a Mac); you can't simply type them or copy & paste them from this message. Nor is it practicable to add them via any of the standard Word dialogues. Likewise, you can't type or copy & paste the chevrons (i.e. '« »') - they're part of the actual mergefields, which you can insert from the mailmerge toolbar. The spaces represented in the field construction are all required. Instead of the ¶ characters, you should use real line/paragraph breaks.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
Reply

Tags
if statement, mail merge, mail merge help



Similar Threads
Thread Thread Starter Forum Replies Last Post
Mail Merge Duplication of address on merge RICKY Mail Merge 1 09-26-2012 03:14 PM
Mail Merge If statement Mail Merge Function not Noticing 'True' vs. 'False' Statement danellekent Mail Merge 1 04-27-2012 02:19 AM
Mail Merge If statement Conditional merge fields in mail merge Aude Mail Merge 1 01-06-2012 07:38 PM
Mail Merge If statement Mail merge will not format date field generated by Excel IF statement borntorun75 Mail Merge 3 12-16-2011 06:28 AM
Mail Merge If statement Saving INDV mail merges During the mail merge sedain121 Mail Merge 2 10-04-2011 07:52 PM

Other Forums: Access Forums

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