Prepare Your Excel Data Source For Mail

Worlds best Ms Office Tutorial content. Find anything about Ms Office Tutorial on this site.

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.

Creating A Table Of Contents To Navigate To Other Dashboards Data Visualization Training Schedule Navigation
Creating A Table Of Contents To Navigate To Other Dashboards Data Visualization Training Schedule Navigation from www.pinterest.com

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.