Re: Merge using PDF Template



When you say that you can "certainly bring the data in using Excel", do you
mean that you can automate the process of populating the fields on the .pdf
from with data from Excel.

If that is the case, and the data that you want to use on the form is
presently in a table in a Word document, select that table and then copy it
to the clipboard and then paste it into Excel.

I suspect however that the statement that I quoted above is not really the
case and I do not think that it is something that can be done using
mailmerge in Word. Googling for AutoFill PDF Form however turns up a number
of leads that claim to do what you want. One example is

http://www.evermap.com/automailmerge.asp

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

"Mishelley" <Mishelley@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:9101A7ED-6B5D-4EE8-A22E-DFD7CC85072E@xxxxxxxxxxxxxxxx
Good Morning,
I hope you can help ASAP since I'd like to automate this process today. I
have a 12 page application form in pdf format that I would like to
pre-fill
for our users. I would like to use mail merge somehow to merge the
applicants data onto the form. However, I cannot see how it is possible
in
Word to place the fields on the primary document. I can certainly bring
the
data in using Excel.

Please let me know the best method for this. Thank you!

Michelle


.



Relevant Pages

  • RE: More about trying to automation multiple Excel instances
    ... Conserning "impossibility to automate multiple Excel Instances" - my be I ... Microsoft Online Community Support ...
    (microsoft.public.excel.programming)
  • Get username of user with open file
    ... I am writing some VBA code to open a file (in this case Excel, ... could in future be a PDF, Word document or something else). ...
    (microsoft.public.vb.winapi)
  • WorkSheet.PageSetup.CHartSize Property
    ... I've automated quite a bit with excel and every so often one of these ... Dialog I can set "Fit to Page" and it automatically adjusts the zoom factor ... ChartSize property, but when I step over that line in the Application I'm ... Worksheet, and set the "FIt to Page" there, so How can I forcibly automate ...
    (microsoft.public.excel.programming)
  • Re: Automate task w/VBA ?
    ... It might be easier to do this in Excel. ... VBA has the same functions so you could automate this completely, ... > notepad, strip these characters and manually count the ...
    (microsoft.public.word.vba.general)
  • Re: Automating mail merge from excel
    ... Excel or Word or from some other appropriate app. ... Indeed there are several differences between Shell and normal automation, ... I can see perhaps you might want to automate the creation of your Mail ... Filter your data as required, copy it to a dedicated sheet ...
    (microsoft.public.excel.programming)