Producing | search
Click here to view Producing news from 60+ newspapers.
Bookmark or Share- Mail merge using an Excel spreadsheet - Microsoft SupportHow to use an Excel spreadsheet with mail merge in Word to create mailing lists for labels, envelopes, and documents.
- Data sources you can use for a mail merge - Microsoft SupportRecipients of a mail merge usually come from a list of names and data in an existing list, like an Excel spreadsheet, or your Outlook contacts list. The existing list could also be any database that you can connect to. If you don't already have a list, you can type one up in Word as part of the mail merge process.
- Insert mail merge fields - Microsoft SupportUse Address Block, Greeting Line, and other merge fields to create a mail merge file from your mailing list.
- Set the rules for a mail merge - Microsoft SupportSetting up rules is done after selecting recipients for the mail merge, and after inserting merge fields in the document.. Go to Mailings > Rule, and choose a rule based on the descriptions below. For example, you're sending out the same invitation for a quarterly meeting.
- Create a form in Word that users can complete or printIn Word, you can create a form that others can fill out and save or print. To do this, you will start with baseline content in a document, potentially via a form template. Then you can add content controls for elements such as check boxes, text boxes, date pickers, and drop-down lists.
More
