Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 04-26-2012, 12:38 PM
danellekent danellekent is offline Mail Merge Function not Noticing 'True' vs. 'False' Statement Windows 7 32bit Mail Merge Function not Noticing 'True' vs. 'False' Statement Office 2010 32bit
Novice
Mail Merge Function not Noticing 'True' vs. 'False' Statement
 
Join Date: Apr 2012
Posts: 1
danellekent is on a distinguished road
Default Mail Merge Function not Noticing 'True' vs. 'False' Statement

Hello -



I have been using a mail merge function for some time now that has successfully been doing what I need it to do - then suddenly, it stopped.

Please see the attached document for my explanation below to make sense. The attached document is merged with an excel file with each of the merge fields.

The function that stopped was when the privacy_flag merge field = true, it is supposed to knock everything else out from that point down to the email. But now regardless if the flag is true or false, it shows the address and pertinent that shouldn't be showing.

Anyone have any ideas on this? I'm sure there is some more elegant way to do what I did - but it's homegrown and as knowledgeable as I am.

Thanks in advance for any help! Please ask questions if needed, I know I can be confusing.
Attached Files
File Type: docx 1. Participant List with Address.docx (65.2 KB, 7 views)
Reply With Quote
  #2  
Old 04-27-2012, 02:19 AM
macropod's Avatar
macropod macropod is offline Mail Merge Function not Noticing 'True' vs. 'False' Statement Windows 7 64bit Mail Merge Function not Noticing 'True' vs. 'False' Statement Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
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 danellekent,

Your mailmerge test looks for the word 'true', all in lower case, with no spaces either side, in a data field named 'Privacy Flag'. If the source data differ in any way, or if the data field has been renamed, the test will fail and the 'private' data will be displayed.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
Reply

Tags
mail merge problem

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
IF formula returns TRUE instead of evaluating COUNTIF ColinC Excel 4 12-28-2011 08:21 AM
Mail Merge Function not Noticing 'True' vs. 'False' Statement Mail merge will not format date field generated by Excel IF statement borntorun75 Mail Merge 3 12-16-2011 06:28 AM
Launching a form or comment box when a cell value turns to false cran29 Excel 0 10-25-2011 10:40 AM
Mail Merge Function not Noticing 'True' vs. 'False' Statement MSWord false pattern or background????? controlengineer Drawing and Graphics 3 04-02-2011 06:14 AM
Mail Merge Function not Noticing 'True' vs. 'False' Statement Macro not staying true oluc Word VBA 4 11-21-2010 08:10 AM

Other Forums: Access Forums

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