How to auto-populate a multiple page PDF form?

**stralim** · 10-10-2010, 08:27 AM

Hello all,
I am wondering how to auto-populate a multiple page PDF form from Excel data. What type of code or scripting is needed? Does something already exist?
Kindly,
Jennifer

**xld** · 10-10-2010, 10:47 AM

I don't know what you are using to create PDF, but I have found that inserting page breaks where required works fine for me.

**shawnhet** · 10-10-2010, 11:50 AM

If I read you right here, you have an existing .pdf form that you want to populate from your spreadsheet data. The way I would typically do this would be to go to Zamzar.com and convert the .pdf into a Word or Publisher file that your system could read and then use the Mail Merge function on Word or Publisher to generate individual copies of the forms( for printing or emailing or whatever).

There will be some fiddling around to get the mail merge to look decent(I find Publisher easier to work with for this sort of stuff), but it will save you from typing each form out individually.

Cheers,

**stralim** · 10-11-2010, 09:24 AM

Hello Shawn, thank you for the reply. I would need to send the file back via email to the client as a PDF form. So converting to word, auto populate, and then converting back to the PDF form is the process? I am wondering if I can setup something to do this automatically.

Hello XLD, The PDF are generated using professional version.

**xld** · 10-11-2010, 09:42 AM

Professional version of what? Did you try inserting page breaks?

**shawnhet** · 10-11-2010, 11:07 AM

Jennifer, I'm still not entirely sure what you are trying to do here. I was assuming that the .pdf form you want to auto-populate was already generated (for instance by a third party). My solution was what I typically do when I am given an existing form that I pull off the internet, for example. You should obviously adapt my procedure for your situation. For instance, if you have software that can convert .pdfs to Word you don't need to use Zamzar.

From what it sounds like you want, you may need something like the Add-in available on the following page to save individual documents for each of the merged forms. (Disclaimer: I have never used this Add-In, use at own risk - but it seems to be right what you would need).

http://www.gmayor.com/individual_merge_letters.htm

Once you have saved the auto-populated forms individually, you can then convert them to .pdf(using whatever software you are using) and email them. This process could be automated using VBA, I'm sure, but more details would be necessary.

I'm not very familiar with .pdf conversion software myself, so I can't really help you there.

Cheers,

10-10-2010, 08:27 AM	#1
stralim VBAX Newbie Joined: Oct 2010 Posts: 4 Kb Entries: 0 Articles: 0	How to auto-populate a multiple page PDF form? Hello all, I am wondering how to auto-populate a multiple page PDF form from Excel data. What type of code or scripting is needed? Does something already exist? Kindly, Jennifer
Local Time: 04:26 PM Local Date: 05-22-2013 Location:

10-10-2010, 10:47 AM	#2
xld Distinguished Lord of VBAX VBAX Expert Joined: Apr 2005 Posts: 23,118 Kb Entries: 3 Articles: 2	I don't know what you are using to create PDF, but I have found that inserting page breaks where required works fine for me. ____________________________________________ Nihil simul inventum est et perfectum Abusus non tollit usum Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen! James Thurber
Local Time: 11:26 PM Local Date: 05-22-2013 Location:

10-10-2010, 11:50 AM	#3
shawnhet VBAX Regular Joined: Mar 2010 Posts: 12 Kb Entries: 0 Articles: 0	If I read you right here, you have an existing .pdf form that you want to populate from your spreadsheet data. The way I would typically do this would be to go to Zamzar.com and convert the .pdf into a Word or Publisher file that your system could read and then use the Mail Merge function on Word or Publisher to generate individual copies of the forms( for printing or emailing or whatever). There will be some fiddling around to get the mail merge to look decent(I find Publisher easier to work with for this sort of stuff), but it will save you from typing each form out individually. Cheers,
Local Time: 03:26 PM Local Date: 05-22-2013 Location:

10-11-2010, 09:24 AM	#4
stralim VBAX Newbie Joined: Oct 2010 Posts: 4 Kb Entries: 0 Articles: 0	Hello Shawn, thank you for the reply. I would need to send the file back via email to the client as a PDF form. So converting to word, auto populate, and then converting back to the PDF form is the process? I am wondering if I can setup something to do this automatically. Hello XLD, The PDF are generated using professional version.
Local Time: 04:26 PM Local Date: 05-22-2013 Location:

10-11-2010, 09:42 AM	#5
xld Distinguished Lord of VBAX VBAX Expert Joined: Apr 2005 Posts: 23,118 Kb Entries: 3 Articles: 2	Professional version of what? Did you try inserting page breaks? ____________________________________________ Nihil simul inventum est et perfectum Abusus non tollit usum Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen! James Thurber
Local Time: 11:26 PM Local Date: 05-22-2013 Location:

10-11-2010, 11:07 AM	#6
shawnhet VBAX Regular Joined: Mar 2010 Posts: 12 Kb Entries: 0 Articles: 0	Jennifer, I'm still not entirely sure what you are trying to do here. I was assuming that the .pdf form you want to auto-populate was already generated (for instance by a third party). My solution was what I typically do when I am given an existing form that I pull off the internet, for example. You should obviously adapt my procedure for your situation. For instance, if you have software that can convert .pdfs to Word you don't need to use Zamzar. From what it sounds like you want, you may need something like the Add-in available on the following page to save individual documents for each of the merged forms. (Disclaimer: I have never used this Add-In, use at own risk - but it seems to be right what you would need). http://www.gmayor.com/individual_merge_letters.htm Once you have saved the auto-populated forms individually, you can then convert them to .pdf(using whatever software you are using) and email them. This process could be automated using VBA, I'm sure, but more details would be necessary. I'm not very familiar with .pdf conversion software myself, so I can't really help you there. Cheers,
Local Time: 03:26 PM Local Date: 05-22-2013 Location: