|
- Mail merge using an Excel spreadsheet - Microsoft Support
How to use an Excel spreadsheet with mail merge in Word to create mailing lists for labels, envelopes, and documents
- Prepare your Excel data source for a Word mail merge - Microsoft Support
If your data source is an existing Excel spreadsheet, then you just need to prepare the data for a mail merge But if your data source is a tab delimited ( txt) or a comma-separated value ( csv) file, you first need to import the data into Excel, and then prepare it for a mail merge
- Use mail merge for bulk email, letters, labels, and envelopes
Your first step in setting up a mail merge is to pick the source of data you'll use for the personalized information Excel spreadsheets and Outlook contact lists are the most common data sources, but if you don't yet have a data source, you can type it up in Word, as part of the mail merge process
- How to use the Mail Merge feature in Word to create and to print form . . .
This article explains how to use the Mail Merge feature in Microsoft Word to create and to print form letters by using data from a Microsoft Excel worksheet When you use the Word Mail Merge feature, Word merges a main document with a recipient list to generate a set of output documents:
- Use mail merge in Word to send bulk email messages
When ready, go to Mailings > Finish Merge > Merge to E-Mail Merge to E-Mail is unavailable if you have not selected your default email program Choose the To merge field, the subject, and whether to send as text, HTML, or as an attachment
- Use mail merge to personalize letters - Microsoft Support
Mail merge lets you create a batch of personalized letters where each letter is identical in layout, formatting, text, and graphics, except for personalized parts like the salutation Newer Windows versions Newer Mac versions
- Mail merge with envelopes - Microsoft Support
Use mail merge to print envelopes that are addressed to the people on your mailing list
- Data sources you can use for a mail merge - Microsoft Support
Here are few examples of data sources you can use for mail merge in Word Excel spreadsheet An Excel spreadsheet works well as a data source for mail merge Data should be on one sheet and well formatted so that it can be read well with Word For more information, see Prepare your Excel data source for mail merge Outlook Contact List
|
|
|