Prepare Your Excel Data Source For Mail. Heres how to associate your prepared Excel worksheet containing your mailing list with your Word document. Your file will be automatically imported as a new Google spreadsheet which becomes your mail merge recipient list and data.
1Click Kutools Plus Send Emails see screenshot. Youll use your Excel spreadsheet as the data source for the recipient list. Your data source.
If a column contains a date format the column for text prior to entering the date values or for an existing date column add a single quote as the first character before the date.
If you havent created the list yet despite Excels lack of the mailing label function we still highly recommend you use Excel since its better for organizing and maintaining data than using a Word table. This can be a new document or an existing document. 2In the Send Emials dialog box please select the data range that you want to use and then specify the recipient addresses attachments and subject as you need see screenshot. Choose Database Fields to see the list of fields that are in your data source.