I'm using Access 2007. On a form, I have a button with VBA code to send an
email. It autopopulates the TO, FROM, SUBJECT, and BODY of an Outlook email
from fields on the form, and it also attaches a PDF file.

My question is: How can I autopopulate the fillable PDF form with some of
the fields from the Access Form BEFORE it attaches the PDF form to the
email--without having to manually do it first before clicking the "Send
Email" button on the form?

The closest thing I've been able to find is a dll called iTextSharp, which
apparently was created specifically to work with pdf documents, including
autofilling pdf form fields. The caveat: it works for about every language
except VBA. Oh, there was a post regarding using it in VBA on Experts
Exchange, but I'm not willing to pay money to see their answers.

I even went through Lebans ReportToPDF module to see if he might have
something... no luck.

If you google iTextSharp.dll you'll find plenty of info for Java, ASP, .NET,
C# etc. Maybe you can make something of it work for VBA.

There are a few applications that you can purchase at upwards of $100 to do
this as well.

good luck! I'd be very curious to see if there is free solution available
for VBA.

--
Jack Leach
www.tristatemachine.com

"I haven't failed, I've found ten thousand ways that don't work."
-Thomas Edison (1847-1931)



"CAM" wrote:

> I'm using Access 2007. On a form, I have a button with VBA code to send an
> email. It autopopulates the TO, FROM, SUBJECT, and BODY of an Outlook email
> from fields on the form, and it also attaches a PDF file.
>
> My question is: How can I autopopulate the fillable PDF form with some of
> the fields from the Access Form BEFORE it attaches the PDF form to the
> email--without having to manually do it first before clicking the "Send
> Email" button on the form?

Thank you for your time, Jack. I will do a google search on iTextSharp that
you mentioned. Since it doesnt work with VBA, then maybe it will be possible
to use Visual Basic and then have my VBA code call a VB script procedure. I
will follow up on this lead. Again, thank you for your time.

Sincerely,

Cheryl

"Jack Leach" wrote:

> The closest thing I've been able to find is a dll called iTextSharp, which
> apparently was created specifically to work with pdf documents, including
> autofilling pdf form fields. The caveat: it works for about every language
> except VBA. Oh, there was a post regarding using it in VBA on Experts
> Exchange, but I'm not willing to pay money to see their answers.
>
> I even went through Lebans ReportToPDF module to see if he might have
> something... no luck.
>
> If you google iTextSharp.dll you'll find plenty of info for Java, ASP, .NET,
> C# etc. Maybe you can make something of it work for VBA.
>
> There are a few applications that you can purchase at upwards of $100 to do
> this as well.
>
> good luck! I'd be very curious to see if there is free solution available
> for VBA.
>
> --
> Jack Leach
> www.tristatemachine.com
>
> "I haven't failed, I've found ten thousand ways that don't work."
> -Thomas Edison (1847-1931)
>
>
>
> "CAM" wrote:
>
> > I'm using Access 2007. On a form, I have a button with VBA code to send an
> > email. It autopopulates the TO, FROM, SUBJECT, and BODY of an Outlook email
> > from fields on the form, and it also attaches a PDF file.
> >
> > My question is: How can I autopopulate the fillable PDF form with some of
> > the fields from the Access Form BEFORE it attaches the PDF form to the
> > email--without having to manually do it first before clicking the "Send
> > Email" button on the form?

As an alternative, you may consider this:
http://www.datapigtechnologies.com/f...einreport.html

HTH,
Ryan---

--
Ryan---
If this information was helpful, please indicate this by clicking ''Yes''.


"CAM" wrote:

> Thank you for your time, Jack. I will do a google search on iTextSharp that
> you mentioned. Since it doesnt work with VBA, then maybe it will be possible
> to use Visual Basic and then have my VBA code call a VB script procedure. I
> will follow up on this lead. Again, thank you for your time.
>
> Sincerely,
>
> Cheryl
>
> "Jack Leach" wrote:
>
> > The closest thing I've been able to find is a dll called iTextSharp, which
> > apparently was created specifically to work with pdf documents, including
> > autofilling pdf form fields. The caveat: it works for about every language
> > except VBA. Oh, there was a post regarding using it in VBA on Experts
> > Exchange, but I'm not willing to pay money to see their answers.
> >
> > I even went through Lebans ReportToPDF module to see if he might have
> > something... no luck.
> >
> > If you google iTextSharp.dll you'll find plenty of info for Java, ASP, .NET,
> > C# etc. Maybe you can make something of it work for VBA.
> >
> > There are a few applications that you can purchase at upwards of $100 to do
> > this as well.
> >
> > good luck! I'd be very curious to see if there is free solution available
> > for VBA.
> >
> > --
> > Jack Leach
> > www.tristatemachine.com
> >
> > "I haven't failed, I've found ten thousand ways that don't work."
> > -Thomas Edison (1847-1931)
> >
> >
> >
> > "CAM" wrote:
> >
> > > I'm using Access 2007. On a form, I have a button with VBA code to send an
> > > email. It autopopulates the TO, FROM, SUBJECT, and BODY of an Outlook email
> > > from fields on the form, and it also attaches a PDF file.
> > >
> > > My question is: How can I autopopulate the fillable PDF form with some of
> > > the fields from the Access Form BEFORE it attaches the PDF form to the
> > > email--without having to manually do it first before clicking the "Send
> > > Email" button on the form?

Hi Ryan. I appreciate your response. I like it and could possibly use it in
other situations. However, in this case though, I dont know if it will work
for what I want. It's my fault, I didnt say this in my original post, but I
need my client to be able to fill in the other fields in the fillable PDF
form and email it back to me.

The PDF form that gets attached to my email has a "Submit" button on it that
emails it directly back to me after the client has completed the form and
clicks "Submit".

I know there is more than one way to skin a cat, so I will keep trying...

I very much appreciate your response.

Sincerely,

Cheryl



"ryguy7272" wrote:

> As an alternative, you may consider this:
> http://www.datapigtechnologies.com/f...einreport.html
>
> HTH,
> Ryan---
>
> --
> Ryan---
> If this information was helpful, please indicate this by clicking ''Yes''.
>
>
> "CAM" wrote:
>
> > Thank you for your time, Jack. I will do a google search on iTextSharp that
> > you mentioned. Since it doesnt work with VBA, then maybe it will be possible
> > to use Visual Basic and then have my VBA code call a VB script procedure. I
> > will follow up on this lead. Again, thank you for your time.
> >
> > Sincerely,
> >
> > Cheryl
> >
> > "Jack Leach" wrote:
> >
> > > The closest thing I've been able to find is a dll called iTextSharp, which
> > > apparently was created specifically to work with pdf documents, including
> > > autofilling pdf form fields. The caveat: it works for about every language
> > > except VBA. Oh, there was a post regarding using it in VBA on Experts
> > > Exchange, but I'm not willing to pay money to see their answers.
> > >
> > > I even went through Lebans ReportToPDF module to see if he might have
> > > something... no luck.
> > >
> > > If you google iTextSharp.dll you'll find plenty of info for Java, ASP, .NET,
> > > C# etc. Maybe you can make something of it work for VBA.
> > >
> > > There are a few applications that you can purchase at upwards of $100 to do
> > > this as well.
> > >
> > > good luck! I'd be very curious to see if there is free solution available
> > > for VBA.
> > >
> > > --
> > > Jack Leach
> > > www.tristatemachine.com
> > >
> > > "I haven't failed, I've found ten thousand ways that don't work."
> > > -Thomas Edison (1847-1931)
> > >
> > >
> > >
> > > "CAM" wrote:
> > >
> > > > I'm using Access 2007. On a form, I have a button with VBA code to send an
> > > > email. It autopopulates the TO, FROM, SUBJECT, and BODY of an Outlook email
> > > > from fields on the form, and it also attaches a PDF file.
> > > >
> > > > My question is: How can I autopopulate the fillable PDF form with some of
> > > > the fields from the Access Form BEFORE it attaches the PDF form to the
> > > > email--without having to manually do it first before clicking the "Send
> > > > Email" button on the form?

Thats a good idea...

--
Jack Leach
www.tristatemachine.com

"I haven't failed, I've found ten thousand ways that don't work."
-Thomas Edison (1847-1931)



"ryguy7272" wrote:

> As an alternative, you may consider this:
> http://www.datapigtechnologies.com/f...einreport.html
>
> HTH,
> Ryan---
>
> --
> Ryan---
> If this information was helpful, please indicate this by clicking ''Yes''.
>
>
> "CAM" wrote:
>
> > Thank you for your time, Jack. I will do a google search on iTextSharp that
> > you mentioned. Since it doesnt work with VBA, then maybe it will be possible
> > to use Visual Basic and then have my VBA code call a VB script procedure. I
> > will follow up on this lead. Again, thank you for your time.
> >
> > Sincerely,
> >
> > Cheryl
> >
> > "Jack Leach" wrote:
> >
> > > The closest thing I've been able to find is a dll called iTextSharp, which
> > > apparently was created specifically to work with pdf documents, including
> > > autofilling pdf form fields. The caveat: it works for about every language
> > > except VBA. Oh, there was a post regarding using it in VBA on Experts
> > > Exchange, but I'm not willing to pay money to see their answers.
> > >
> > > I even went through Lebans ReportToPDF module to see if he might have
> > > something... no luck.
> > >
> > > If you google iTextSharp.dll you'll find plenty of info for Java, ASP, .NET,
> > > C# etc. Maybe you can make something of it work for VBA.
> > >
> > > There are a few applications that you can purchase at upwards of $100 to do
> > > this as well.
> > >
> > > good luck! I'd be very curious to see if there is free solution available
> > > for VBA.
> > >
> > > --
> > > Jack Leach
> > > www.tristatemachine.com
> > >
> > > "I haven't failed, I've found ten thousand ways that don't work."
> > > -Thomas Edison (1847-1931)
> > >
> > >
> > >
> > > "CAM" wrote:
> > >
> > > > I'm using Access 2007. On a form, I have a button with VBA code to send an
> > > > email. It autopopulates the TO, FROM, SUBJECT, and BODY of an Outlook email
> > > > from fields on the form, and it also attaches a PDF file.
> > > >
> > > > My question is: How can I autopopulate the fillable PDF form with some of
> > > > the fields from the Access Form BEFORE it attaches the PDF form to the
> > > > email--without having to manually do it first before clicking the "Send
> > > > Email" button on the form?