snapshot or pdf

[rml]

I have a command button on a form which sends it to outlook with a snapshot
attachment. I works fine but how can I make it create a pdf instead?

Thanks.

DoCmd.SendObject acSendReport, "Test13", acFormatSNP, "[email protected]; [email protected]",
, "[email protected]", "E-mail subject", "Body text something - " & strIdentify

 

[Noëlla Gabriël]

Hi,

Have you tried the acFormatPDF in stead of acFormatSNP?
I use this format with access 2007.

 

[Tom van Stiphout]

On Mon, 20 Oct 2008 06:06:01 -0700, rml

Why does this line create a snapshot? Check the syntax in the help
file and you will find the third argument has something to do with
that. While you're there, also read about the Add-In you need to have
installed to support PDF.

-Tom.
Microsoft Access MVP

 

[rml]

I changed it to acFormatPDF and when I click my command button, I get a list
of file formats. XLS, html, txt, etc.... I think it's looking for the pdf
file type. Do I have to install an add-in for a pdf? Do you know of one for
access 2003?

Thanks.

 

[rml]

It works fine? Not sure why you are asking that? I'm just trying to make it
create a pdf instead. Do you know of an add-in for creating pdf's?

Thanks.

 

[Tom van Stiphout]

On Mon, 20 Oct 2008 08:13:01 -0700, rml

The A2007 help page on SendObject has this Note :
You can save as a PDF or XPS file from a 2007 Microsoft Office system
program only after you install an add-in. For more information, search
for "Enable support for other file formats, such as PDF and XPS" on
Office Online.

-Tom.
Microsoft Access MVP

 

[Tom van Stiphout]

On Mon, 20 Oct 2008 08:11:01 -0700, rml

There is no Add-In from Microsoft for A2003.

Perhaps this will be of some help:
http://www.lebans.com/reporttopdf.htm

-Tom.
Microsoft Access MVP

 

[Dale Fye]

Before I got Office 2007, I used PrimoPDF as my PDF software. It basically
acts as a printer driver, so you select it as your printer in the print
dialog.

The disadvantage is that I had to print the report to a file, then email it.

--
HTH
Dale

Don''t forget to rate the post if it was helpful!

email address is invalid
Please reply to newsgroup only.