Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 03-18-2011, 07:34 AM
curatorfm curatorfm is offline Merge excel info into word letter. Windows XP Merge excel info into word letter. Office 2007
Novice
Merge excel info into word letter.
 
Join Date: Mar 2011
Posts: 1
curatorfm is on a distinguished road
Default Merge excel info into word letter.

I am trying to set up a word letter that will use info from an excel spreadsheet. I have no problems putting in straight info but I have a problem with using an "if" statement to select info based on a check or lack of a check in an excel cell.



I have a cell that is checked if something is to be selected and is left blank if it is not to be accepted. I need to be able to put into the letter the contents of another cell and the statement "has been accepted" or "has not accepted" based on a check or no check in a cell.

Can anyone lay out this for me and help me to make it work in the merged letter?

Thank you so much for your assistance.
Reply With Quote
  #2  
Old 03-20-2011, 04:26 AM
macropod's Avatar
macropod macropod is offline Merge excel info into word letter. Windows 7 32bit Merge excel info into word letter. Office 2000
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,065
macropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant future
Default

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.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
Reply

Thread Tools
Display Modes


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
Merge excel info into word letter. 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
Merge excel info into word letter. Transfer Outlook info to Excel methedr Outlook 1 05-24-2010 05:48 AM
Merge excel info into word letter. importing bulk info from excel... herbycanopy Word 3 04-03-2010 10:50 AM

Other Forums: Access Forums - Senior Forums

All times are GMT -7. The time now is 04:08 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2021, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2021 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft