![]() In the Home tab, within the Ribbon, click the dropdown arrow besides General.To make any changes, select the cell or a range of cells that contains the numerics.Numeric data for any contact, like ZIP codes, discount percentages, mileages, currencies, etc., should be in the appropriate number format.For example, in the current tutorial, every available contact detail of the customer James Butt is accessible between cells A2 and J2. You need to ensure that the spreadsheet file contains contact data as one record per row pattern.You should edit the column headers to match the placeholder names that you’ll be using in the email or letter template document.Word will use these column headers as Merge Fields when you use Microsoft Word mail merge. The first row should only have column headers starting from cell A1.To avoid any inconsistencies in your bulk emails or letters, you need to tweak your Excel file as mentioned below: If you don’t have an Excel file with contact details, you may use this sample Excel file for trial purposes. For mail merge, you’ll use Excel to create a database that Word will use later on. Add any additional fields you’d like and make it look pretty.Microsoft Excel workbook database is most preferred when you need to use mail merge in Word.You should now see an Intelligent Mail Barcode! ![]() We’ll need to select a font before it will look like a barcode. In this video, you’ll learn the basics of working with Mail Merge in Word 2019, Word 2016, and Office 365. Don’t worry… those random letters makes up our Intelligent Mail Barcode. 1.2M views 7 years ago Microsoft Word 2016.Click on Preview Results, and you will see what we’ve got so far.Next, we’ll insert the Intelligent Mail Barcode.Choose a name format and double check everything looks alright in the preview before clicking OK.In this example, I want to keep my mailing list unchanged. A dialog box will pop up to let you manipulate and confirm your mailing list.Make sure Use an existing list is selected.In this example, we have started with a blank document, so just click Next: Select recipients.In this example, I would like to create a letter. On the Mail Merge wizard panel, choose the type of document.Go to Start Mail Merge > Step by Step Mail Merge Wizard… The Mail Merge wizard will appear as a panel on the right.In a new Word document, click on the Mailings tab.We’re half way there! Start a new mail merge in Microsoft Word: Finally, give it a file name and click Finish to save it somewhere.The default mapping is usually sufficient, so just click Next.Click Next to go to the Export Fields step.In the Export Presort Information screen, ensure Presorted pieces is checked.Select Microsoft World mail merge as the export file format.Here’s how.Įxport the presorted mailing list from Postalsoft: The final product will give us a nicely merged letter with Microsoft Word, complete with an Intelligent Mail Barcode. In this tutorial, I will use the sample mailing list that’s presorted as Standard automated letters. The SAP Community Network blogs, however, gives support engineers, like me, some freedom to provide how-tos with third-party software.īefore we start, you’ll need a presorted mailing list. Microsoft Word, a third-party software, is technically outside of our support. Every now and then, we get questions on how to go about doing a mail merge with Microsoft Word and DeskTop Mailer/Business Edition.
0 Comments
Leave a Reply. |