You can use any text file that has data fields separated (or delimited) by tab characters or commas and data records separated by paragraph marks. You can export Apple contacts into an Excel spreadsheet and use it as your mailing list for mail merge. You can retrieve contact information directly from your Outlook Contact List on to Word. For more information, see Prepare your Excel data source for mail merge. Data should be on one sheet and well formatted so that it can be read well with Word. Here are few examples of data sources you can use for mail merge in Word.Īn Excel spreadsheet works well as a data source for mail merge. The list is saved as a document file that you can reuse.įor details about creating a new list, see Set up a new mail merge list with Word. If you don't have a data source yet, choose Create a New List, and then use the dialogs that open to create your list. For more information, see Use Outlook contacts as a data source for a mail merge. To use this as your data source, choose Choose from Outlook Contacts. You can retrieve contact information directly from your Outlook contact list in Word. Go to Mailings > Select Recipients > Use an Existing List, then choose New Source to open the Data Connection Wizard.Ĭhoose the type of data source you want to use for the mail merge, and then select Next.įollow the prompts in the Data Connection Wizard to complete the data connection to the merge document. Other database files To access other kinds of data sources, you'll run the Data Connection Wizard: For more information, see Use mail merge to send Access data to Word. For more information, see Prepare your Excel data source for a Word mail merge.Īccess database With Access, you can select data from any table or query defined in the database. To learn more, check out the links in the course summary.Important: No matter what type of file you use as a data source, be sure to save it on your local computer or a file share saving at an HTTP location isn't supported for mail merge.Įxcel spreadsheet An Excel spreadsheet works well as a data source for mail merge if all data is well-formatted and on one sheet so that it can be read by Word. Now you have all the information you need to do basic Mail Merge tasks.īut there is a lot more to know about Mail Merge- things like adding Rules and custom fields, and working with Excel spreadsheets. Then, if everything works okay, click All and OK. If you have never printed an envelope with the printer you are using, it might be a good idea to click Current record and print one envelope first as a test. Load your envelopes in the printer and click OK. Last, click Finish & Merge and Print Documents. That will help us find both files if later, we need to. In this case, we created the envelope for a specific letter, so we'll save it in the same folder with the same name and append 'Envelope' to the end. Now, Save the envelope, pick a location, and type a name. Click OK.Ĭlick Preview Results and check through the names, if you want.įinally, let's add a return address in the paragraph that Word added in the upper left corner. Click Never include the country/region in the address, and uncheck Format address according to the destination country/region. We can set this up the same way as the address block in movie 2.įirst, choose a less-formal name format. Go to the HOME tab and click Show/Hide Paragraph Marks if you want to see where the paragraphs were placed. Click in the area where the delivery address goes, and select the paragraph that Word placed there for the address block. You can click Edit Recipient List if you want to make any changes, but we'll leave the list as is. We'll use the list we created in the last movie.Ĭlick Use an Existing List, locate the list, and click Open. Click OK.Īnd Word changes the size of the document to match the envelope size. Press Reset to bring the settings back to the recommended feed method for your printer. If you find it doesn't print correctly, you can try changing these settings. It's a good idea to print a test envelope before you run your final Mail Merge. This tab shows you how to feed envelopes into your printer.įor example, this printer requires that you place the envelope against the top and right edges of the printer tray, face down and rotated clockwise. You can also adjust the layout of the Return address and Delivery address and click Font to change font formatting. You start by entering your Envelope Options.Ĭhoose one of the standard sizes, or enter a Custom size. You can use the wizard if you want to, but this can be faster. On the MAILINGS tab, click Start Mail Merge, and Envelopes. Then, go to FILE, click New and open a Blank document. You create Mail Merge Envelopes the same as email messages or letters.įirst, click FILE and Close the current document.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |