Skip to main content
H
HenrySugar10
New Participant
November 19, 2019
Question

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

  • November 19, 2019
  • 2 replies
  • 6818 views

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?

    This topic has been closed for replies.

    2 replies

    alexandraFR
    alexandraFR
    New Participant
    November 27, 2019

    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

    H
    HenrySugar10Author
    New Participant
    November 28, 2019

    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? )

    Thom Parker
    Thom Parker
    Community Expert
    November 19, 2019

    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? 

    Thom Parker - Software Developer at PDFScriptingUse the Acrobat JavaScript Reference early and often
    H
    HenrySugar10Author
    New Participant
    November 19, 2019

    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. 

    H
    HenrySugar10Author
    New Participant
    November 20, 2019

    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

     


    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.

    Terms & ConditionsAccessibility statement
    Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices