Mailing
Solved
nyco13
Posted messages
528
Registration date
Status
Member
Last intervention
-
nyco13 Posted messages 528 Registration date Status Member Last intervention -
nyco13 Posted messages 528 Registration date Status Member Last intervention -
Hello,
I have a problem with my mail merge.
I created my database with Excel, I entered
Abbreviated Title: Mr, Mrs, Ms
Title: Monsieur, Madame, Mademoiselle
Last Name: Bleu, Blanc, Rouge
First Name: Nicolas, Angel, Sarah
Address: rue de l'étoile
Postal Code: 13000
City: Marseille
I saved my database and then opened Word for my letter.
Select recipients: existing list, I selected my Excel document.
I set up my merge fields.
My problem lies with the Rules.
I select Monsieur, then click on Rules and then on If... Then... Else.
If Abbreviated Title equals: Mr
Insert the following text: Monsieur
Else, this: Madame
I can distinguish between the abbreviated title Mr with Monsieur and Mrs with Madame,
but I am missing a condition for Ms with Mademoiselle and I don't see how to do it in the rules.
Do you have any idea?
Thank you in advance
Configuration: Microsoft Windows XP Media Center Version 2002 Service Pack 2
Intel(R) Core(TM) 2 CPU 6300
@ 1.86GHz 1.86GHz
1.00 GB of RAM
I have a problem with my mail merge.
I created my database with Excel, I entered
Abbreviated Title: Mr, Mrs, Ms
Title: Monsieur, Madame, Mademoiselle
Last Name: Bleu, Blanc, Rouge
First Name: Nicolas, Angel, Sarah
Address: rue de l'étoile
Postal Code: 13000
City: Marseille
I saved my database and then opened Word for my letter.
Select recipients: existing list, I selected my Excel document.
I set up my merge fields.
My problem lies with the Rules.
I select Monsieur, then click on Rules and then on If... Then... Else.
If Abbreviated Title equals: Mr
Insert the following text: Monsieur
Else, this: Madame
I can distinguish between the abbreviated title Mr with Monsieur and Mrs with Madame,
but I am missing a condition for Ms with Mademoiselle and I don't see how to do it in the rules.
Do you have any idea?
Thank you in advance
Configuration: Microsoft Windows XP Media Center Version 2002 Service Pack 2
Intel(R) Core(TM) 2 CPU 6300
@ 1.86GHz 1.86GHz
1.00 GB of RAM
9 answers
-
Hello, you should do this in your recipient list that you made in Excel, it will save you the trouble of dealing with rules in Word! Plus, it's a word processor, not a calculation tool :/
So, in your recipient list in Excel, you add a column (or a row depending on whether your list is in rows or columns). I imagine you must have lots of correspondents, so doing it all by hand would take too long. I suggest entering a IF() formula in the last one.
IF(a1=Mr,"Monsieur",IF(a1=Mme,"Madame","Mademoiselle"))
with the abbreviated civility in a1 -
Hello and thank you for taking the time to respond to me.
The way you describe it sounds nice; I will give it a try.
Now, I was taught this way with Word and it is possible, but when I took notes, I must have skipped a part, so I am stuck trying to insert Mademoiselle.
In my letter with the abbreviated title Mlle, it gives me Dear Madam instead of Dear Mademoiselle. -
=SI(A1="Mr";"Monsieur";SI(A1="Mme";"Madame";"Mademoiselle"))
:-) -
The formula works well in Excel but doesn't do anything in Word.
I don't think this is the right solution.
In Word, I created my sample letter and then inserted the contact list (my database) and then I inserted the merge fields for:
Mr/Name/First Name/Address/Zip Code/City
Then I added an If…Then…Else rule for "Dear Sir, Dear Madam, Dear Miss."
Now I want to set a rule so that Mr changes to Mrs based on the abbreviated title but also takes Miss into account.
Because, as I explained above, my problem is that the abbreviated title Ms is naming Madame instead of Miss.
How can I do this? -
Hello nyco13.
You did not correctly apply what tyranausor explained to you:
- he invited you to create a new column in Excel, so a new field in your document; therefore, there is no longer a need to create rules.
Best regards.
Retirement is great! Especially in the Caribbean... :-)
Raymond (INSA, AFPA, CF/R) -
Hello, I was told how to do it.
The solution is: select Mr. and add a Title merge field. -
Hello, so in Word you click on "Salutation" which allows you to choose from a dropdown list whether you want "Dear Sir," "Sir," "Madam and Sir," etc...
-
nyco, you mentioned not THE solution, but ONE of the various solutions...
--
Retirement is great! Especially in the Caribbean... :-)
Raymond (INSA, AFPA, CF/R) -
Yes it's true, but it was this solution that I was looking for.
In 2 clicks it was done, I searched for hours pfff.
Anyway, it's not a big deal, thank you for taking the time to reply to me.
And for anyone who might face the problem, they will be happy to find the solution.
Have a good evening, see you soon.
