Merge excel info into word letter.

macropod · #2 03-20-2011, 04:26 AM

Hi curatorfm,

To use an IF field this way, you can code the field like:
{IF{MERGEFIELD CheckState}= "X" {MERGEFIELD ExtraText}}
or:
{IF«CheckState»= "X" «ExtraText»}
where 'CheckState' is the name of the mergefield used to determine the check status, 'X' is the field value that toggles it 'checked' and 'ExtraText' is the name of the field containing the additional text.

Note: The field brace pairs (ie '{ }') for the above example are created via Ctrl-F9 - you can't simply type them or copy & paste them from this message. Likewise, you can't type or copy & paste the chevrons (ie '« »') - they're part of the actual mergefields, which you can insert from the mailmerge toolbar.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Info from excel spreadsheet to Power point	anyquist	Office	0	01-31-2011 12:29 PM
Word Merge Connection to Excel failing	techexpressinc	Mail Merge	3	01-26-2011 01:27 PM
Merge to New Document - saved letter continues to ask for SQL source	Brandi	Mail Merge	2	06-16-2010 08:08 AM
Transfer Outlook info to Excel	methedr	Outlook	1	05-24-2010 05:48 AM
importing bulk info from excel...	herbycanopy	Word	3	04-03-2010 10:50 AM