PDF Format

[thingssocomplex]

Hi Guys,

Is it possible to Print to 'CutePDF' using VBA code in Access.

I am using SendObject but I simply cant speficy output format acFormatPDF.

I was therefore hoping I could print to CutePDF and then somehow use the SendObject to attach to a email!

Is this possible and if yes how would I do it?

 

[KenHigg]

I have not heard of doing this. Is it (CutePDF) a printer option like regular PDF writer?

Maybe you can contact CutePDF support - ?

 

[thingssocomplex]

Hi Ken,

Yes it is a regular printer option so it is selectable from a list. I am amssuming it will be possible to print to cute pdf, however bear in mind when printing to cute pdf it does ask you to save the file on your hard drive.

For format acFormatPDF there is add-on from Microsoft that is meant to work, tried this and it does not work, it only works when you select save as and publish.

 

[KenHigg]

Hi Ken,

Yes it is a regular printer option so it is selectable from a list. I am amssuming it will be possible to print to cute pdf, however bear in mind when printing to cute pdf it does ask you to save the file on your hard drive.

I though saving it as a pdf was the purpose for the whole pdf drill?

 

[thingssocomplex]

Hi ken,

That is correct, but I don't know how to save as using VBA to even generate the report, is it possible for me to select the printer cute PDF using VBA!

 

[KenHigg]

In report design view do File->Page Setup on the Page tab you set the printer for this specific report to the CUTEPDF thing. The when you do the vba print command it will print to pdf.

 

[thingssocomplex]

Hi Ken,

Tried that it wont work keeps returning to default printer, I wish thing were easier

 

[thingssocomplex]

Okay after some tinkering I managed to attach a PDF file to a email bypassing the Save option. However I need to attach more than one file to a email how do I do this, is it even possible

I've tried "Report Name" & "Report Name" fails other symbols bring up a compile error!!!

 

[irish634]

Gotta love the Lebans code for outputting a report to pdf.
Search "Lebans PDF" and you'll find it.

For attaching to email, use automation. Tons of stuff on it in here.

 

[wiklendt]

Okay after some tinkering I managed to attach a PDF file to a email bypassing the Save option. However I need to attach more than one file to a email how do I do this, is it even possible

I've tried "Report Name" & "Report Name" fails other symbols bring up a compile error!!!

mind posting your solution? i'm sure many others on this forum would benefit from your hard work

 

[CarlM1975]

Please could you post your code for printing to cute pdf bypassing the save option