merge Excel data to multiple PDF's (mailing labels)

[HenrySugar10]

My scenario: I upload my excel files with to UPS 500 lines of excel, 1 line per order. (same with other postal services) I get back from UPS 500 mailing labels on pdf, which I print on my label machine.  At the bottom of each label there is plenty of empty space which I would like to use. I would like to paste / merge data from the original excel which created the pdf, so for example line 2 column w, goes at the bottom of label 2, line 3 column w, goes at the bottom of label 3, etc etc. I do this manually every day, and it takes alot of time, can anyone advise?

[Thom Parker]

Yes, this can be done with a script.  Are the labels one per page or are they in a regular arrangment?  Is the order of the labels exactly the same as the order of items in the spreadsheet?  And are there the same number of them?

If the answer to all these questions is Yes, then the script is on the simpler side. Not simple, but reasonable.

Do you have any programming skills? If not, would you pay to have someone else update the labels, or to create a script for you to use? 

[HenrySugar10]

Hi thank you for your fast response. yes they are 1 per page, same order, same number of lines, as number of pages (labels). The text goes in the same location on each label. I have meddled with importing the labels into word, adding with vb from excel, and then exporting again. But I am not sure the 3D barcode and regular barcode would survive. I would rather a solution where the original pdf remains intact. 

[Thom Parker]

Here are the steps for a solution (there are a few different possible ways to go about this)

1. Export the Excel data to a CSV file.

2. Write an Acrobat automation script to

     1) parse the CSV.

     2) loop over each row

             a) create a field at the correct location on the page with the same number as the row

             b) set the field value to desired data from a colum in the CSV data.

That's pretty much it. You can find more infomation on the details Acobat Automation scripting here:

https://www.pdfscripting.com/public/Automating-Acrobat.cfm

Here's an article that explains coordinates and placing fields

https://www.pdfscripting.com/public/PDF-Page-Coordinates.cfm

[HenrySugar10]

Thank you. I will find somone that can write this script

I am thinking of a excel where I paste all the data, and press a button, and all the text goes to the correct place on the bottom of the PDF label.

[Thom Parker]

PM me about creating writing the script.

[alexandraFR]

You can use a third party plugin for Adobe Acrobat, AutoMailMerge by Evermap to do this (http://evermap.com/AutoMailMerge.asp).

Here is a link to the description of how the plugin works if you want to make sure it works for your application:  https://www.evermap.com/Tutorial_AMM_CreatingMultipleLabelsPerPage.asp

[HenrySugar10]

I think you have not read my problem. I have *********existing********* pdf's which need information added later.  Evermap does mailmerge to new pdfs etc etc, nothing that solves my issue, as above (do you work for  Evermap? )