Greetings!
I'm fairly new to mail merge docs and have inherited a mess.
The mail merge works except for populating with department head names/titles and I can't seem to get it to work right.


What I'm looking for is something similar to this:
{ IF {MERGEFIELD DeputyDirector} persons name and title} { IF {MERGEFIELD AssistantDirector} persons name and title}{ IF { MERGEFIELD deputy director and assistant director} names and titles}

I may be over thinking it. I don't know. I do know about Ctrl+F9. I just need the right syntax and can't seem to get it right. Usually it comes back blank.

What are the actual field names in the data source? It seems unlikely you'll have three separate fields named 'DeputyDirector', 'AssistantDirector', and 'DeputyDirector and AssistantDirector' there.

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

There are only two data fields. What I need is for the mail merge to do is populate if it is either one or the other or both. So Deputy director or assistant director or deputy director and assistant director. I need it to: if deputy director then deputy director+name or if assistant director then assistant director+name or if deputy director and assistant director then both+name.

You still have said what the field names in the data source are...

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

Sorry, thought I did. It's:
ProcessFields_AssistantDirectorApproval
ProcessFields_DeputyDirectorInfrastructureProgramm ingApproval

It's pulling from an online database that we don't manage in-house.

You could use a field construction like:
Note: The field brace pairs (i.e. '{ }') for the above example are all created in the document itself, via Ctrl-F9 (Cmd-F9 on a Mac or, if you’re using a laptop, you might need to use Ctrl-Fn-F9); you can't simply type them or copy & paste them from this message. Nor is it practical to add them via any of the standard Word dialogues. Likewise, the chevrons (i.e. '« »') are part of the actual mergefields - which you can insert from the 'Insert Merge Field' dropdown (i.e. you can't type or copy & paste them from this message, either). The spaces represented in the field constructions are all required.

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

Okay, I'll give it a run through and see what I get. Thank you for your assistance, it's greatly appreciated.

Okay, I've given it a few tries and can't seem to get it to populate correctly.
Either it comes up blank, which means I didn't do it correctly, or it shows "Assistant Director name and" without the quotes.

This is exactly what I've got in the field:
{IF«ProcessFields_AssistantDirectorApproval»<> "" "Assistant Director Khalid Bazmi{IF«ProcessFields_DeputyDirectorInfrastructur eProgramming»<> "" " and "}}{IF«ProcessFields_DeputyDirectorInfrastructureP rogramming<> "" "Deputy Director Infrastructure Programming Nardy Khan"}

Is there a way to add a return line between the two also?

You can have pretty much whatever content you want. For example, where I've shown " and ", you might replace either or both spaces with line breaks or paragraph breaks.

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