Hello to everyone,




I have a merge document with multiple Content Control Fields. Fields are populated from SQL database.



Is there any way to insert if statements in the Content Control Fields?


Additionally, I would like to change the date format from yyyy/mm/dd to dd/MM/yyyy.


Any help would be greatly appreciated.

Content Controls are not fields. Please clarify.

You should also read the numerous articles in the Mailmerge Tips and Tricks 'Sticky' thread at the top of this forum: https://www.msofficeforums.com/mail-...ps-tricks.html

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

It is Rich Text Content Control.

I didn't find something relevant for Rich Text Content Controls in Mailmerge Tips & Tricks.


Is it possible to insert if statements and to edit the format of values such as currency and date?


Docs are populated from SQL database.

You can change the type of control from rich text to date and set the date format as required, but you will lose the existing value if you change the type.


You would need a macro to resolve the value of the control.

__________________
Graham Mayor - MS MVP (Word) (2002-2019)
Visit my web site for more programming tips and ready made processes www.gmayor.com

So why are you using a Content Control for a mailmerge instead of using a mergefield?

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

The docs have already been in live production on a CRM core system.

We are trying to fine tune them in order to minimize user's modifications upon their release.


I was just wondering if there is a way to insert if statements or to create nested Content controls.

It is not possible to embed a Content Control in a Field of any kind and have the Content Control survive the merge. Mergefields can be embedded in Content Controls, however, such that a Content Control will display the embedded Mergefield's result upon execution.

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

Ι see.


So, if i insert in the Content Control a statement such as:
{ if { [Alex1s85] }<> "" "Date: { [Alex1s85] \@"dd-MM-yyyy" }"
it will work?

What is [Alex1s85]?

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

[Alex1s85] is the the content control's bookmark.

So what does this have to do with a mailmerge?

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

Please move the thread or delete it.