Mail Merge

%3CLINGO-SUB%20id%3D%22lingo-sub-2789362%22%20slang%3D%22en-US%22%3EMail%20Merge%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2789362%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20trying%20to%20use%20an%20old%20mail%20merge%20which%20I%20set%20up%20a%20couple%20of%20years%20ago.%20I%20am%20using%20a%20new%20excel%20data%20file%20which%20I%20have%20just%20populated%20with%20a%20couple%20of%20lines%20of%20data.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhen%20I%20try%20the%20mailmerge%20to%20word%2C%20I%20only%20get%20access%20to%20one%20or%20the%20other%20line%20of%20data.%20On%20the%20right%20side%20of%20the%20screen%2C%20it%20is%20giving%20me%20an%20option%20of%20recipient%201%20or%202%3F%3F%20I%20have%20set%20up%20the%20excel%20file%20with%20up%20to%204%20lines%20of%20data%2C%20I%20can't%20find%20why%20it%20is%20not%20doing%20what%20it%20did%20before%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20it%20because%20I%20am%20now%20using%20365%20whereas%20before%20I%20was%20using%20Office%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2789362%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2806261%22%20slang%3D%22en-US%22%3ERe%3A%20Mail%20Merge%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2806261%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1167677%22%20target%3D%22_blank%22%3E%40AndyCarter4%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYou%20probably%20have%20to%20re-create%20the%20mail%20merge%20in%20365%20word%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2806877%22%20slang%3D%22en-US%22%3ERe%3A%20Mail%20Merge%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2806877%22%20slang%3D%22en-US%22%3EHi%2C%20I%20sorted%20out%20the%20initial%20problem%2C%20it%20was%20me%20with%20brain%20fade.%20Now%20that%20I%20have%20the%20mailmerge%20up%20and%20running%2C%20I%20have%20another%20problem%3B%20the%20dates%20are%20displayed%20in%20American%20format%20(mm%2Fdd%2Fyyyy)%3CBR%20%2F%3EEven%20though%20they%20are%20UK%20format%20in%20Excel%20data%20file%3F%20I%20can't%20see%20how%20to%20change%20it.%3C%2FLINGO-BODY%3E
Occasional Contributor

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?

7 Replies

@AndyCarter4 

 

You probably have to re-create the mail merge in 365 word

Hi, I sorted out the initial problem, it was me with brain fade. Now that I have the mailmerge up and running, I have another problem; the dates are displayed in American format (mm/dd/yyyy)
Even though they are UK format in Excel data file? I can't see how to change it.

@AndyCarter4 

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.

Hi Hans, thanks very much for your reply. I am not sure how to proceed?
I have the following: {MERGEFIELD "Date_1"} + 3 more with Date_2, Date_3 and Date_4.
I hope that makes sense?
I need to populate a form with up to 4 entry lines in order to recover my expenses.
Sorry Hans, I forgot to say that I don't see \*MERGEFORMAT

Andy

@AndyCarter4 

 

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" }

Hi Hans, thank you so much. Everything is working really well now. I much appreciate your help.

Regards

Andy