Sep 27 2021 11:22 AM
I am trying to use an old mail merge which I set up a couple of years ago. I am using a new excel data file which I have just populated with a couple of lines of data.
When I try the mailmerge to word, I only get access to one or the other line of data. On the right side of the screen, it is giving me an option of recipient 1 or 2?? I have set up the excel file with up to 4 lines of data, I can't find why it is not doing what it did before?
Is it because I am now using 365 whereas before I was using Office?
Oct 02 2021 04:41 PM
Oct 03 2021 06:15 AM
Oct 03 2021 06:37 AM
Mailmerge ignores the number formatting specified in Excel.
You must format the merge field in Word.
Click in the date merge field.
Press Shift+F9 to display the field code. You'll see something like
{ MERGEFIELD StartDate \* MERGEFORMAT }
where StartDate is the name of the field. Replace \* MERGEFORMAT with \@ "dd/MM/yyyy" so that it looks like
{ MERGEFIELD StartDate \@ "dd/MM/yyyy" }
Press F9 to hide the field code and to update the result.
Oct 03 2021 09:04 AM
Oct 03 2021 09:48 AM
Solution
Change them to
{ MERGEFIELD "Date_1" \@ "dd/MM/yyyy" }
{ MERGEFIELD "Date_2" \@ "dd/MM/yyyy" }
{ MERGEFIELD "Date_3" \@ "dd/MM/yyyy" }
{ MERGEFIELD "Date_4" \@ "dd/MM/yyyy" }
Oct 04 2021 05:22 AM
Oct 03 2021 09:48 AM
Solution
Change them to
{ MERGEFIELD "Date_1" \@ "dd/MM/yyyy" }
{ MERGEFIELD "Date_2" \@ "dd/MM/yyyy" }
{ MERGEFIELD "Date_3" \@ "dd/MM/yyyy" }
{ MERGEFIELD "Date_4" \@ "dd/MM/yyyy" }