function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
SkyofCloudsSkyofClouds 

Word Mail Merge

I'm using the Mail Merge Template to generate a Word document based on information entered in Salesforce (in a custom object).  This is the merge field I'm using:

{MERGEFIELD TENANT_EXTRA_BILL_TO \* MERGEFORMAT}

 

The problem is that if the TENANT_EXTRA_BILL_TO field is blank, Word prints a line like this: ___________ instead of just a blank line.  Would anyone know the exact format of an IF statement to specify that if the field is left blank in Salesforce it should just print a blank line (or nothing at all)?

 

 

Also, is there any way to force lower case in the merged document for a certain field? I've tried this:

{MERGEFIELD TENANT_EXTRA_FREQUENCY \* lower \* MERGEFORMAT} but it doesn't seem to work.

 

Any help will be very much appreciated.

 

ET

smoodysmoody
The blank line problem has been around for quite a while and, to date, I haven't heard of a solution.
trueblade.comtrueblade.com
>Would anyone know the exact format of an IF statement to specify that if the field is left blank in Salesforce it should just print a blank line (or nothing at all)?

I need to know this too. I have tried several combinations and the resultant post-merge doc is not able to evaluate salesforce fields in an IF statement.

Thanks.

--
Robert Burgoyne

Message Edited by trueblade.com on 10-10-200702:07 AM