Word for Office 365, Word 2019, Word 2016, Word 2013 and Word 2010 Details It may make more sense to follow its instructions than the ones in the rest of this help topic. Microsoft actually has an online article and video about creating mailing labels using Word, with your data coming from an Excel spreadsheet (or various other sources), at. The same type of actions may be possible with WordPerfect or other word processing programs, but truthfully, we just haven't tried them. The following mail merging instructions work for Word 2010 or later. From Excel, you can re-save it as a regular Excel file.) (If you use Letters ⇒ Mass Mailing to do the export, which is one of the options in that Exporting topic, it exports to a CSV file, but then gives you an option to open that in Excel. For this purpose, the best option is to export to Excel. See Exporting Data from the Program to learn your options for exporting data. One way to do that is to export the desired data from DONATION, then do your own mail merge in your word processor. However, in some limited cases you may want to generate your own mailing labels or envelopes, perhaps because you want different information included on them, you want to use a size of mailing labels or envelopes that isn't supported by the above reports, or you want to use a different font. See the sections on Mailing Labels and Envelopes for more details on these reports. Save the document by click File ( Office button) > Save.Most users will be completely satisfied with the built-in label and envelope reports in DONATION. Click Preview Results in Preview Results group, then the labels are created.
Click Update Labels in the Write & Insert Fields group under Mailings tab. Repeat step 7 to insert all the information you need, see screenshot:
Put the cursor at the start of the document and click Mailing > Insert Merge Field, then select the information you want to be included in the labels. Then delete all 《Next Record》in the document, see screenshots: If the list you need to import is in an Excel workbook, there will be a Select Table dialog popping up after you selecting the workbook and clicking Open button. In the Select Data Source, select the file and click OK.
Click Mailings > Select Recipients, select the option for your needs. Then click Home > Show/Hide Editing Marks for more convenient to edit the labels. In the Label Options dialog, select North American Size from the Product number list. Open a new Word document, and click Mailings > Stat Mail Merge > Labels.
0 kommentar(er)
