![]() For more info, see Sort the data for a mail merge or Filter the data for a mail merge. Note: You also can sort or filter the list to make it easier to find names and addresses. In Mail Merge Recipients, clear the check box next to the name of any person who you don't want to receive your mailing. Right-click on your field again and select “Toggle Field Codes” to get back to the normal view. Edit your mailing list Choose Edit Recipient List.After the field name and before the end curly bracket add a space and the string “dd/MM/yy”.Your field will now appear like this where Date is the name of your filed (column heading in Excel).At step 4 “Write you letter” right-click you date field and select “Toggle Field Codes”.Select Recipients Select Use an existing list then browse for the file created in Step 2. Select Starting Document Having already opened the drafted email, select Use the current document, then click next. Open Word and run through the Mail Merge wizard. Select Document Type Select the radio dial for E-mail messages and click next at the bottom of the sidebar.This guide will show you how you can change the date format to the UK format, but the process would be identical if you need to format the date to any other format. In Excel, the dates were in the UK format but when the data came across in the mail merge they were changed to month day rather than day month. All the dates were showing in the American format. I recently had a case where one of my colleagues was performing a mail merge from an Excel document.
0 Comments
Leave a Reply. |