Below are instructions to create a mailing list and labels using the Contact List reports in QuickBooks Online, MS Excel and MS Word. These instructions may vary dependent on the Microsoft Office Excel or Word versions that you may have. So, you may want to use the Help File in MS Excel or Word for more accurate instructions. PLEASE NOTE: From this point forward, We offer the steps below with MS Word as a workaround but are unable to provide technical support for that product or Excel. Therefore, if you have any difficulty with this process, you will need to contact Microsoft technical support. Mail Merge List in QuickBooks Online • Choose Reports from the menu on the left. • In the ' Go to report' field enter the name of the report ie Vendor(Supplier) Contact List or Customer Contact List • Select the report • Click Customize next to the report. • Click the Change Columns button. • Add Full Name and any applicable address information you need to the Selected Columns area. • Click OK, and then Run Report. • Click the Excel button at the top of the report, and save the report to your desktop. Next, follow these steps in Microsoft (MS) Excel: • Open the report that you saved to your desktop. • Delete all header rows from the spreadsheet, leaving only column headings. • Delete any extra leading columns to the left of the Full Name column. • Review all records (rows) to make sure both Full Name and Billing Address are populated with data for each customer. • Delete any rows you will not be using in the address field (you do not need both billing and shipping). • Go to File, and then Save As. Save this spreadsheet under a different name, such as CustomerList.xls, to your desktop. To create a mail merge template: Review the Help Index (F1) in your specific version of MS Word. The following steps vary depending upon your version of MS Word. • Open MS Word, and open a new (blank) document. • Click Tools. • Select Letters and Mailings, and then Mail Merge. • Under 'Select document type,' click Labels. • Click Next. • Click Label Options to select the printer and the type of label. • Click Next. • Under 'Select recipients,' click Use an Existing List • Click Browse, and find the CustomerList.xls you saved to your desktop. • On the pop-up window for Table, Make sure check mark is in First Row of Data Contains Column Headers. Templates Support Buy Office 365. Journal submission tracking list Word. Microsoft in education; Office for students. • On the pop-up window for Mail Merge Recipients you should see your recipients listed in a table. Mark the records you wish to print. Check for duplicates. • Click Next. • In the Arrange Your Labels view, click on More Items. • Set the Insert Merge Field pop-up window as follows: • Set Insert Option to Database Fields. • Click Full Name and Insert. • Click Billing Address and Insert. • Click Close. Now, working directly in the preview document, with the address field highlighted, you may click next to the address field, and use the enter key. Then the address field will be placed underneath the name field. For Example: > > Steps to Replicate labels: •. If you are running a business and want to keep everything neat and organized as you are putting things out in the mail, then you will want to use a mailing list template. A good template will keep you from losing track of all that you have done, and all that you still need to do, and that will help to keep you organized. It will help your work day to go by smoother, and you will appreciate that. A good mailing list template will take a lot of stress off of you, and that will make you appreciate your job a lot more. Advertisements When you are trying to get things out in the mail, you should have a way of staying organized and knowing what you are doing. You should have something there to help you out as you are getting this done. And that is just what a mailing list template is. You don’t have to do things on your own any longer. Use a mailing list template, and you will be able to get everything done in a good way. You will feel relaxed as you are getting things out in the mail because you will know that everything is getting taken care of, thanks to the mailing list template and all that it will do for you. There are many ways that you can stay organized as you go about doing your business, and a mailing list template is one of the most useful tools that you can use. Use this to help you keep track of all that you are doing, and you will be happy with the way that you are able to stay organized. Mailing List Template for Word.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
April 2018
Categories |