Not sure why Microsoft have made this so complicated. I think you are just not following the instructions precisely.ġ) Set up an xlsx file with two headings DATE and DATETEXTĢ) enter the a these 2 dates in the DATE column:ģ) enter this text in the DATETEXT column & don't let it format into a date:Ħ) Click mailings, Start mail merge & letters, Select Recipients & use existing list & select the list you just made & click OKħ) Click Insert merge field & click DATE & then OKĩ) Click Insert merge field & click DATETEXT & then OKġ0) Click Preview Results & jump through the 2 entries. The DATE field will be showing the date as mm/dd/yyyy REALLY ANNOYINGġ1) Click once on the DATE field (to highlight it)Įnter this text MMM yyyy" so that the field becomes:ġ3) VERY IMPORTANT: Note the lower case dd, UPPERCASE MMM, lower case yyyyġ4) Click preview results until the data shows.
MAIL MERGE WORD MAC HOW TO
In this tutorial, we will learn how to use a mail merge in making labels from Excel data, set up a Word document, create custom labels and print labels easily.įigure 1 – How to Create Mailing Labels in Excel Step 1 – Prepare Address list for making labels in Excel Scroll through entries & I hope we are sorted.We can create or print a mailing list by using Microsoft Excel to keep it organized.
MAIL MERGE WORD MAC FOR MAC
#How to do mail merge in word and excel for mac how to
MAIL MERGE WORD MAC CODE
Next, we will fill in our data ( Format the Zip Code column to enter numbers as text)įigure 3 – Create labels from excel spreadsheet.#How to do mail merge in word and excel for mac code
We will select the address list including column headers and go to Formulas.
In the Defined names group, we click on Define name.įigure 4 – Define Name for mailing labels from excel We will type in a name for our address list in the Name box.įigure 5 – Name address list for labelling in excel.Once we are done, we will save our Excel worksheet.Step 2 – Set up the Mail Merge document in Word We will open a blank Word document in Ms Word 2007, 2010, 2013 or 2016įigure 6 – Blank word document to convert excel to word labels.