Microsoft Office Forums

Go Back   Microsoft Office Forums > Microsoft Word > Mail Merge

Reply
 
LinkBack Thread Tools Display Modes
  #1  
Old 04-26-2012, 12:38 PM
danellekent danellekent is offline Windows 7 32bit Office 2010 32bit
Novice
 
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, 1 views)
Reply With Quote
  #2  
Old 04-27-2012, 02:19 AM
macropod's Avatar
macropod macropod is offline Windows 7 64bit Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 19,358
macropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to behold
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
[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 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
MSWord false pattern or background????? controlengineer Drawing and Graphics 3 04-02-2011 06:14 AM
Macro not staying true oluc Word VBA 4 11-21-2010 08:10 AM


All times are GMT -7. The time now is 11:36 AM.


Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.
MSOfficeForums.com is not affiliated with Microsoft