how can I print labels from submissions

I would like to set up a report or something so that the person reviewing the submissions can click and print out a mailing label (yes, a mailing label for the post office) on a local printer. We get one or two catalog requests every day and have to send them out right away. Downloading and importing the data in to the database that does this now takes longer than typing it in.

Any info

Keith 

Hello Keith,

I'm not sure this method can be done, but can you give us more information on this? Are the maling labels coming from the submissions data? 

I also noticed that you mentioned about downloading and importing data into the database takes longer than typing it in, can you tell us your existing process? Perhaps there is a shorter method on doing this if you are manually downloading and importing information to your database. Perhaps using Webhooks which you can set to submit a copy of the submissions via back-end or Post data submission which you can point your thank you page and let the thank you page handle the importation automatically can remove that middle-process of manually importing data for you.

Yes the data for printed labels is coming from the form submissions. We download an excel spread sheet and add it to our databases when we do an email blast or do mass mailings every month. However, when a customer completes a form requesting a catalog or a brochure on a product – usually one or two per day – we need to mail one out as soon as possible. Right now a staff person get’s the email from JotForm, sit’s down at a computer, and types in the name address etc. in to a standalone Microsoft Access database that has the Avery brand label form templates set up and prints one or two addresses. (We plan to get a new dedicated label printer from Dymo who has been making them for decdes http://www.dymo.com/en-US.)

The staff person doing this task daily in most companies is an administrative person not familiar with importing database files, mapping fields etc. – And it’s a laborious effort for just one or two names. They typically just type it in from the email and print.

What we want to be able to print directly to a label printer of a popular make like avery, or have the ability to format an output page perhaps in a PDF so we can print ourselves.

JotForm is probably large enough a company to connect with Dymo like others have as seen on the link below.

http://www.dymo.com/en-US/dymo-labeling-needs/mailing-shipping-labeling/mailing-shipping-labeling/labelwriter-450-label-printer

I will look at those links you sent.

If you need to use your own templates that are populated from an access database, the only thing I can thing of would be to set up a script to populate your database:

https://www.jotform.com/answers/714822-how-to-connect-the-form-to-my-MS-Access-database

Other than that you can create a shipping label on one of your notifications.

Simply edit the body of the notification to look the way your label should look like.

Once there is a submission, you will get two e-mails:

1 - Normal submission

2 - Mailing label 

Here is a sample of the second label:

On that notification, not all the fields will be included, but only those needed for a mailing label.

You can then simply print out the mailing label from the email. 

Here's a quick test form to show you how it would work:

https://form.jotform.com/63325049397967

This would not work if you need to retain your current process.

Thank you David for the response and test page. (Sorry it took me so long!) Thats a great work-around. Can I create a notification that would print out the field contents without the labels so instead of reading

Joe Smith
Street Address: 123 Main Avenue
City: Appleville
State / Province: CA
Postal / Zip Code: 94948

It would read

Joe Smith
123 Main Avenue
Appleville, CA  94948

This would be good to know for a lot of applications - how to call specific fields in "mailing address" and to suppress field labels.

From there just copy and paste it in to the Dymo label printer app and bam - mailing label.

I am also trying to create a PDF of above. Outlook insists on adding their headers on emails. 

Wow, this thread is very old. I am not sure if the guide below will help you but please check it and let us know if you have any questions. 

How-to-Strip-Payment-Labels-and-Separate-Payment-Info-on-Email-Alerts

Thanks - I got it working - However a link on the page to a related guide about striping headers off mailing addresses answered my questions. Nevertheless - You got me on the right path and gave me hope! :)

https://www.jotform.com/help/92-How-to-Strip-Headers-from-Postal-Addresses-in-Email-Alerts

Suggestion: You might consider editing some of the headers in the forum posts to make them search friendly; maybe say "remove field labels..." along with or instead of "Striping Headers..." or DELETE labels.

Thank you for your feedback and suggestion.

If you need further help, please contact us again here in the Support Forum.