When I look at the spreadsheet itself, dates are shown (as they have been formatted that way). When I click 'edit recipient list' in Word and it shows the Mail Merge Recipient list, if I scroll to the right to the two date fields, one shows a date as a serial number, (the one I am having problems with) and the second shows the date in the US style Why does one date appear correctly but the other appear as a serial number? This is driving me insane. Mail Merge can decrease your time significantly when producing large volumes of letters, envelopes, labels and much more.
#How to mail merge labels from excel to word youtube how to
You will learn how to set up the Excel file with all the important information needed for a seamless merge. I have set the file format conversion check box in advanced options as suggested on other posts on this forum. Learn how to create a Mail Merge using Word and Excel. I have tried formatting as 'date' and as 'custom', and again both dates have identical formatting, but one remains different. The format in the Excel worksheet is also identical. I have cut and paste and re-written but to no effect. In both date field codes I have added the switch: "dd MMMM yyyy" This switch is identical in both merge fields, including spaces. The second mail merge date field displays an Excel date of 26/3/15 as: 26 March 2015 - which is exactly what I want. The first mail merge data field displays an Excel date of 27/3/14 as: 41725 added create a sheet of avery mailing labels from an excel worksheet of names and addresses. we will retrieve data from excel to create the merge. quickly take a spreadsheet with contacts and in this tutorial you'll learn how to use mail merge in word for letters.
Hi, I have a mail merge word document that imports two date fields from Excel, but one of the dates is not displaying correctly. learn how to mail merge to create address labels using microsoft word and excel.