Mail merge word: dear
Solved
tof1664
Posted messages
434
Registration date
Status
Membre
Last intervention
-
Sb -
Sb -
Hello,
first of all, I thank you for taking some of your time to read my message.
here is my problem:
I am currently making a mail merge for a business letter. I have my client database with their contact information and I would like to set this up with an IF function:
for automatic insertion
if it's Mrs. ---> Dear customer
if it's Mr. ---> Dear customer
and if it's Mrs., Mr. or a business ---> Dear customer, dear customer
I found out how to set it for Mrs. or Mr. but I can't figure out how to set a second condition for Mrs., Mr. or a business.
Does anyone know the solution to my dilemma?
I hope I have been clear in stating my problem.
I thank you in advance for your responses and wish you an excellent day and a very good weekend.
tof
first of all, I thank you for taking some of your time to read my message.
here is my problem:
I am currently making a mail merge for a business letter. I have my client database with their contact information and I would like to set this up with an IF function:
for automatic insertion
if it's Mrs. ---> Dear customer
if it's Mr. ---> Dear customer
and if it's Mrs., Mr. or a business ---> Dear customer, dear customer
I found out how to set it for Mrs. or Mr. but I can't figure out how to set a second condition for Mrs., Mr. or a business.
Does anyone know the solution to my dilemma?
I hope I have been clear in stating my problem.
I thank you in advance for your responses and wish you an excellent day and a very good weekend.
tof
Configuration: Windows XP Internet Explorer 7.0
3 réponses
WORD 2007:
Better late than never as they say, I have the answer having struggled today with this formula I found out how to do it and it’s actually quite simple:
In the mailings tab,
the writing and insertion fields section:
at the top right there is the "Rule" in a dropdown menu and there you will find the famous "if then else" formula and many others.
There you go, I hope this answer will save some of you from pulling your hair out.
Better late than never as they say, I have the answer having struggled today with this formula I found out how to do it and it’s actually quite simple:
In the mailings tab,
the writing and insertion fields section:
at the top right there is the "Rule" in a dropdown menu and there you will find the famous "if then else" formula and many others.
There you go, I hope this answer will save some of you from pulling your hair out.
Hello,
here is the response I gave some time ago for an English version, it just needs a little adaptation but it should be fine:
Make the first condition by inserting a keyword: if then else. To display "Monsieur" leave the else empty.
Then in your document, press ALT + F9, the fields of your mail merge appear in code, and in the code of the "if then else" (if then else), insert the next conditions as in the following example:
starting code: { IF { MERGEFIELD title } = "m" "Monsieur" "" }
addition 1 { IF { MERGEFIELD title } = "m" "Monsieur" { IF { MERGEFIELD title } = "mme" "Madame" "Dear customer" }} (remove "" before the brace)
By proceeding as follows, you can insert as many conditions as you want; your formula will end with as many braces ( } ) as there are conditions.
The simplest way to avoid mistakes in the conditions is to do copy/paste
To return to normal display press ALT + F9
here is the response I gave some time ago for an English version, it just needs a little adaptation but it should be fine:
Make the first condition by inserting a keyword: if then else. To display "Monsieur" leave the else empty.
Then in your document, press ALT + F9, the fields of your mail merge appear in code, and in the code of the "if then else" (if then else), insert the next conditions as in the following example:
starting code: { IF { MERGEFIELD title } = "m" "Monsieur" "" }
addition 1 { IF { MERGEFIELD title } = "m" "Monsieur" { IF { MERGEFIELD title } = "mme" "Madame" "Dear customer" }} (remove "" before the brace)
By proceeding as follows, you can insert as many conditions as you want; your formula will end with as many braces ( } ) as there are conditions.
The simplest way to avoid mistakes in the conditions is to do copy/paste
To return to normal display press ALT + F9
Thank you for your response; but in the fields and writing tab, this "RULE" does not exist; I have something called "address block" but it is inactive.
Thank you very much
Dorine
You must not have looked closely. The "Rules" button is indeed present in the "Mailings" tab in the ribbon at the top of the screen, both in the 2007 version of Word and in 2010 or 2013.
Here is the image:
https://www.commentcamarche.net/contents/1739-word-regles-de-publipostage
C-Claire