Adobe Community
Turn on suggestions Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Showonly | Search instead for
Did you mean:
- Global community
- Language:
- Deutsch
- English
- Español
- Français
- Português
- 日本語コミュニティ
Dedicated community for Japanese speakers
- 한국 커뮤니티
Dedicated community for Korean speakers
Exit
- Home
- Acrobat
- Discussions
- You can use a third party plugin for Adobe Acrobat...
-
- Home
- Acrobat
- Discussions
- You can use a third party plugin for Adobe Acrobat...
1
Community Beginner ,
/t5/acrobat-discussions/merge-excel-data-to-multiple-pdf-s-mailing-labels/td-p/10748831 Nov 19, 2019 Nov 19, 2019
Copy link to clipboard
Copied
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?
TOPICS
Edit and convert PDFs
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
7 Replies 7
Jump to latest reply
Community Expert ,
/t5/acrobat-discussions/merge-excel-data-to-multiple-pdf-s-mailing-labels/m-p/10749231#M229518 Nov 19, 2019 Nov 19, 2019
Copy link to clipboard
Copied
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 PDFScripting
Use the Acrobat JavaScript Reference early and often
Votes Upvote
Translate
Translate
- Follow
- Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
HenrySugar10 AUTHOR
Community Beginner ,
/t5/acrobat-discussions/merge-excel-data-to-multiple-pdf-s-mailing-labels/m-p/10749530#M229536 Nov 19, 2019 Nov 19, 2019
Copy link to clipboard
Copied
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.
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
Community Expert ,
/t5/acrobat-discussions/merge-excel-data-to-multiple-pdf-s-mailing-labels/m-p/10749690#M229544 Nov 19, 2019 Nov 19, 2019
Copy link to clipboard
Copied
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
Thom Parker - Software Developer at PDFScripting
Use the Acrobat JavaScript Reference early and often
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
HenrySugar10 AUTHOR
Community Beginner ,
/t5/acrobat-discussions/merge-excel-data-to-multiple-pdf-s-mailing-labels/m-p/10751026#M229620 Nov 20, 2019 Nov 20, 2019
Copy link to clipboard
Copied
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.
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
Community Expert ,
/t5/acrobat-discussions/merge-excel-data-to-multiple-pdf-s-mailing-labels/m-p/10751733#M229652 Nov 20, 2019 Nov 20, 2019
Copy link to clipboard
Copied
PM me about creating writing the script.
Thom Parker - Software Developer at PDFScripting
Use the Acrobat JavaScript Reference early and often
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
Community Beginner ,
/t5/acrobat-discussions/merge-excel-data-to-multiple-pdf-s-mailing-labels/m-p/10767086#M230578 Nov 27, 2019 Nov 27, 2019
Copy link to clipboard
Copied
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
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
HenrySugar10 AUTHOR
Community Beginner ,
/t5/acrobat-discussions/merge-excel-data-to-multiple-pdf-s-mailing-labels/m-p/10767829#M230618 Nov 27, 2019 Nov 27, 2019
Copy link to clipboard
Copied
LATEST
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 forEvermap? )
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
Resources
About Adobe Acrobat
Adobe Inc
Whats new in Acrobat DC
Adobe Inc
Plan and Pricing
Adobe Inc
Adobe Acrobat features and tools
Adobe Inc
Adobe Acrobat Feature & Workflow
Edit PDFs
Edit Scanned PDFs
PDF Forms
Sign a PDF
FAQs
How to Edit Scanned or Secured document
Rotate | move | delete and renumber PDF pages
Acrobat download and installation help
Copyright © 2024 Adobe. All rights reserved.
Using the Community Experience League Terms of Use Privacy Cookie preferences Do not sell or share my personal information AdChoices
