Instructional Guide: 

Step 1: Prepare the Name column on the spreadsheet. 

Download the Bulk Send spreadsheet. Fill out the Name portion of the signer information. You can do this by manually typing in their information, by copying and pasting from another spreadsheet, etc. 

Screen Shot 2022-02-28 at 12.07.36 PM

 
Step 2: Prepare the Generic Packet Name

Right click on Column A and Duplicate it to the right. 

 

Screen Shot 2022-02-28 at 12.11.48 PM

 

Type your generic packet name in the cell A2 and then drag that name throughout column A.

Screen Shot 2022-02-28 at 12.44.47 PM

 
Step 3: Concatenate Columns A and C into Column B

In Cell B2 type =CONCATENATE(C2, " ", A2). You want to select C2 first if you want the Signer Name (C2) in front of the Packet Name (A2). You want to reverse that if you want the Packet Name (A2) in front of the Signer Name (C2). You want to include the parenthesis with a space in the middle so there is a space between the two names. If you wanted an underscore or something else in between you would want to put "_". 

1

 

Press Enter or Return on your keyboard.

Screen Shot 2022-02-28 at 12.49.52 PM

 

Grab the bottom right hand corner of B2 and drag down to copy the formula throughout Column B. 

Screen Shot 2022-02-28 at 12.53.06 PM

Screen Shot 2022-02-28 at 12.53.17 PM

 

Step 4: Copy the values of Column B and delete Column A.

Copy Column B

Screen Shot 2022-02-28 at 12.56.27 PM

Paste Special -> Values only right back into Column B. This helps remove the formulas. 

Screen Shot 2022-02-28 at 12.57.24 PM

 
Step 5: Delete Column A.

Screen Shot 2022-02-28 at 12.59.15 PM

 
Step 6: Double check your spreadsheet and upload back into the Bulk Send area.

Visually check that your spreadsheet looks correct and only has Columns that have Column Names in row 1. Complete all the other columns in the spreadsheet if you haven't already.

Screen Shot 2022-02-28 at 1.00.35 PM

Save your spreadsheet in a place you will find it. Upload it back into the Bulk Send area.

Screen Shot 2022-02-28 at 1.03.31 PM 

Need additional assistance?

Contact us at support@readysign.com or 866.700.7975.