- MICROSOFT WORD MAIL MERGE FROM EXCEL HOW TO
- MICROSOFT WORD MAIL MERGE FROM EXCEL SOFTWARE
- MICROSOFT WORD MAIL MERGE FROM EXCEL PC
- MICROSOFT WORD MAIL MERGE FROM EXCEL WINDOWS
MICROSOFT WORD MAIL MERGE FROM EXCEL SOFTWARE
Remove software from the Startup folder, or close them.Don't do anything else on the computer while it is doing the mail merge don't have any other applications open.
MICROSOFT WORD MAIL MERGE FROM EXCEL WINDOWS
You can also reduce screen colors and screen resolution.
MICROSOFT WORD MAIL MERGE FROM EXCEL PC
Reboot your PC just before doing the mail merge, so all memory resources are available.In this case, you should apply any or all of the following items, which can generally conserve memory use on a PC: Since mail merging is still a memory-intensive operation, you may still notice slowdowns while merging. You will also want to turn off any anti-virus software you use, or at least configure it so that it won't scan Word documents for viruses.Īnother obvious thing to try is to not merge to a new document, but merge directly to the printer. This should stop Word from trying to repaginate the document during the merge process. First of all, make sure you are using Normal view before you do the merge, and that you turn off background repagination. There are a few things you can do to help speed things up. If you have 20,000 records in your data source, this means you are attempting to create a 20,000 page document! Word won't theoretically choke on such a huge document, but it may slow to a crawl depending on the capabilities of your computer. As each record is fetched and processed, a new page is added to the merged document. The most common method of doing a merge is to create a new document that contains the merged information. If you have many, many records in your data source, though, the mail merge might not run as quickly as you like.įor example, let's say you are merging a large amount of data (10,000 or 20,000 records) with a single-page document to create a form letter. Follow Dave on Twitter.The Mail Merge tool in Word can be very helpful in combining information from a data source (such as names or addresses) with information in a standard document (such as letters or labels). Click Print to print your letters or Edit individual letters to further personalize some or all of the letters.Preview your letter and click Next: Complete the merge.Write a short letter and click Next: Preview your letters. Note that the address block and greeting line are surrounded by chevrons (« »).In the Insert Greeting Line dialog box, choose the greeting line format by clicking the drop-down arrows and selecting the options of your choice, and then click OK.Press Enter on your keyboard and click Greeting line.Clicking Match Fields opens up the Match Fields dialog box, in which you can associate the fields from your list with the fields required by the wizard. Note that you can use Match Fields to correct any problems.In the Insert Address Block dialog box, check or uncheck boxes and select options on the left until the address appears the way you want it to.Click Address block to add the recipients' addresses at the top of the document.Write the letter and add custom fields.Selecting Edit recipient list opens up the Mail Merge Recipients dialog box, where you can edit the list and select or unselect records.Note that now that a list has been created, the Mail Merge Wizard reverts to Use an existing list and you have the option to edit the recipient list.Create a list by adding data in the New Address List dialog box and clicking OK.In this demo we will create a new list, so select Type a new list and then click Create. After you choose it, the Mail Merge Wizard reverts to Use the current document. Note that selecting Start from existing document (which we are not doing in this demo) changes the view and gives you the option to choose your document.
Select Use the current document and then click Next: Select recipients. In this demo we will use the current (blank) document.
Mail merge is also used to create envelopes or labels in bulk. Using Mail Merge, you can easily customize form letters for individual recipients. Mail Merge is most often used to print or email form letters to multiple recipients.
MICROSOFT WORD MAIL MERGE FROM EXCEL HOW TO
How to Use Mail Merge in Microsoft Word See Microsoft Word: Tips and Tricks for similar articles.