Ask a Question
Loading nanoRep Self-Service Support Help Desk
Reviews

You're currently on:

Create and Mail to a Google Sheet

Carly Brown posted this on Oct 11, 2016

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".

 

Create and Mail MMD

 

Click "Create Sheet".

 

Create and Mail MMD

 

Click "Add Address".

 

Create and Mail MMD

 

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.

 

Create and Mail MMD

 

The records you entered will be displayed.  Click "Save to Sheet".  Next, save the sheet with a meaningful name.  It will be imported for use as a mailing list.

 

Create and Mail MMD

 

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

 

Create and Mail MMD

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

Create and Mail MMD

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.

Create and Mail MMD

 

Click "Continue" when you are ready to proceed.

 

Create and Mail MMD

 

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

 

Create and Mail MMD

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.

 

Create and Mail MMD

 

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

Mailing List Center

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

 

Create and Mail MMD

Click2Mail Customer Support is 866-665-2787 or [email protected]  Our hours of operation are Monday - Friday, 9 AM to 8 PM Eastern.

 
Contact Support