Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

Merge excel data into a pdf document with form fields

Posted on 2008-11-20
4
Medium Priority
?
3,121 Views
Last Modified: 2012-08-13
Hi There,

I was wondering if anyone can help with this we need to merge excel data into a pdf a bit like you do a mail merge with a word document. We have limited software options as this is for a client who are very restrictive on downloading products so we must do this with Excel and Adobe Acrobat Standard.

So just to reconfirm the excel has many rows and the pdf document has a few form fields and we need to bring that excel data in to the pdf document into these form fields and do the same technique as a word mail merge to create many doc's...hope that makes sense.

Cheers,

Steve
0
Comment
Question by:keyparker
  • 2
  • 2
4 Comments
 
LVL 13

Accepted Solution

by:
nike_golf earned 2000 total points
ID: 23003391
I use a program called activepdf (https://store.activepdf.com/shopexd.asp?id=128) we use the more robust version but I think the lite version will do what you want.

It allows you to manipulate via an activeX control a PDF document and save the information that you "fill" into fields on the document, it works great.

I don't think your going to find a freebie when it comes to modifying and saving a PDF document.

NG,
0
 

Author Comment

by:keyparker
ID: 23003909
Hi NG

Thanks for that i think i am going to resign that fact this is the best way to go with this.

I will award the points...and especialy as this helps with something else in the future so cheers.

Cheers,

Steve
0
 

Author Closing Comment

by:keyparker
ID: 31518636
Thanks for the help
0
 
LVL 13

Expert Comment

by:nike_golf
ID: 23005621
Glad it can be of use - its a nice control and has done well for us. There are probably other solutions but it was pain free to implement for us.

Good luck!

NG,
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

When you see single cell contains number and text, and you have to get any date out of it seems like cracking our heads.
You need to know the location of the Office templates folder, so that when you create new templates, they are saved to that location, and thus are available for selection when creating new documents.  The steps to find the Templates folder path are …
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…
Many functions in Excel can make decisions. The most simple of these is the IF function: it returns a value depending on whether a condition you describe is true or false. Once you get the hang of using the IF function, you will find it easier to us…

577 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question