Cube Long Arrow Right External Link angle-right Search Times Spinner angle-left

Create and Mail to a Google Sheet

You can create a mailing list during the Mail My Doc by Click2Mail Google Add-on order process.  After creating your Google Doc and clicking "Mail My Doc by Click2Mail" from the Add-on menu, click "Create/Import".

undefined

Click "Create Sheet".

undefined

Click "Add Address".

undefined

Enter mailing address information.  Click "Add +next address" to enter additional addresses.  Click "Add address and finish" when you have entered all of your mailing addresses.

undefined

The records you entered will be displayed.  Click "Save to Sheet".  

undefined

Next, save the sheet with a meaningful name.  

undefined

Now you will import the Google Sheet for use as a mailing list.

Click "Create/Import" again and then click "Import Sheet".

undefined

Select the sheet you want to import and click "Select".

undefined

Now tell us how to print the information in the sheet on your mailpiece.  This is done by dragging the blue boxes seen to the right of "My Sheet Fields" into the white "Click2Mail Fields" boxes.  There is an excellent animated tooltip located on this screen that demonstrates this action.  Your sheet does not need to have all of the "Click2Mail Fields" information in individual columns, but at the minimum, we must have a First Name and Last Name OR Organization field and individual fields for the Address, City, State, Zip and Country (only required if you have international addresses) fields.

undefined

Click "Continue" when you are ready to proceed.

undefined

Select records from the sheet to which you are mailing and click "Continue".

undefined

We will classify your addresses as non-mailable, non-standard, standard or international.  You are encouraged to try correcting non-mailable and non-standard addresses by clicking them and reentering information.  Non-mailable addresses will not be imported.  Click "Continue" when you are ready to proceed.

undefined

Give the sheet a meaningful name.  It will be available for your use as a mailing list in the future.  Click "Import".

undefined

Select the sheet from your list of mailing lists and click "Continue" to proceed through the order process.

undefined