X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
   Reply to this topicStart new topic
> If In Mail Merge, Any Version    
post Jul 31 2017, 05:11 AM

Posts: 1,108
Joined: 17-November 13
From: Orewa New Zealand

I am trying to do an if in mail merge something that says this but I can not seem to get it to work
If company name is not blank then insert the text "Company Name" and Company Name
Company Name is a merged field
I get the first part right but then it ethe puts the words and not the company name or the company name and not the text before it
Go to the top of the page
post Aug 2 2017, 11:55 AM

UtterAccess VIP
Posts: 5,982
Joined: 30-June 11

Just a thought, why not do this in the source query that supplies the Mail Merge data?

Daniel Pineault (2010-2017 Microsoft MVP)
Professional Help: http://www.cardaconsultants.com
Free MS Access Code, Tips, Tricks and Samples: http://www.devhut.net

* Design should never say "Look at me". It should always say "Look at this". -- David Craib
* A user interface is like a joke, if you have to explain it, it's not that good! -- Martin LeBlanc

All code samples, demonstration databases, links,... are provided 'AS IS' and are to be used at your own risk! Take the necessary steps to check, validate ...(you are responsible for your choices and actions)
Go to the top of the page

Custom Search
RSSSearch   Top   Lo-Fi    20th August 2018 - 10:49 PM