Prev: domenica
Next: Conditional Data Entry
From: MK_RF on 30 Nov 2009 11:37
I am seeing the same issue.

My email is Lotus Notes 6.5.1, and I am generating a report in Access 2007.
The report has embedded subreports, so I can't send them as Excel files.

When I preview the report in Access 2007, then click the Microsoft Office
button and choose Email, and choose PDF format, my Lotus Notes client opens
and the report is often (but not always) inserted as CDB##.xls instead of
MyReportName.pdf

Then, when you attempt to open the file, Excel reports that it is an unknown
file format.

Emailing some other type of report (like rtf or xps) seems to work fine.

I have Access2007 SP2.


"mikearelli" wrote:

> I am trying to email a report from Access 2007
> I select eMail then SEND OBJECT AS report.PDF
> The system initiates a new email through Lotus Notes 6.5.5 and attaches
> report.XLS. XLS not PDF....
> This file will not open in Excel. I have to save the file, change the
> extension back to PDF, then send it.
>
> Why would the extension automatically change? How can I stop this from
> happening?
>
> Thanks,
> Michael
From: MK_RF on 30 Nov 2009 14:46
I think the problem has something to do with the temporary files created when
you open an attachment in Lotus Notes.

I found a temp file called MyReportName.pdf in my Notes Temporary files, and
I deleted it, and then I was able to email the PDF successfully.

"MK_RF" wrote:

> I am seeing the same issue.
>
> My email is Lotus Notes 6.5.1, and I am generating a report in Access 2007.
> The report has embedded subreports, so I can't send them as Excel files.
>
> When I preview the report in Access 2007, then click the Microsoft Office
> button and choose Email, and choose PDF format, my Lotus Notes client opens
> and the report is often (but not always) inserted as CDB##.xls instead of
> MyReportName.pdf
>
> Then, when you attempt to open the file, Excel reports that it is an unknown
> file format.
>
> Emailing some other type of report (like rtf or xps) seems to work fine.
>
> I have Access2007 SP2.
>
>
> "mikearelli" wrote:
>
> > I am trying to email a report from Access 2007
> > I select eMail then SEND OBJECT AS report.PDF
> > The system initiates a new email through Lotus Notes 6.5.5 and attaches
> > report.XLS. XLS not PDF....
> > This file will not open in Excel. I have to save the file, change the
> > extension back to PDF, then send it.
> >
> > Why would the extension automatically change? How can I stop this from
> > happening?
> >
> > Thanks,
> > Michael
 | 
Pages: 1
Prev: domenica
Next: Conditional Data Entry