Complex E-mail problem

  • Thread starter Thread starter Ant
  • Start date Start date
A

Ant

Hi All,

I have an procedure in an Access 2000 form that e-mails a
report to specified recipients. One of the fields is a
memo field which is cut off after 250 or so characters. I
used an HTML format for the report which solved the
cutting off of data problem.

The new problem is that it only sends the first page of
the report.

I have tried the following two bits of code.

DoCmd.OutputTo acOutputReport, "Handover Report",
acFormatHTML, "Valid Path Name", True


DoCmd.SendObject acReport, "Handover Report", _
acFormatHTML, "'" & strList & "'", , , "Handover
Report"

The files I created using the send object statement look
for a strange file name CDBIE5Page2.tmp and not the actual
file name when you hold the mouse over the next html.

Does anyone know a easier way of e-mailing a report that
will not cut off data in the memo field?? Or how to fix
the existing problem.

May thanks, (in advance)

Ant
 
Ant said:
Hi All,

I have an procedure in an Access 2000 form that e-mails a
report to specified recipients. One of the fields is a
memo field which is cut off after 250 or so characters. I
used an HTML format for the report which solved the
cutting off of data problem.
Click to expand...

A query or report should not truncate a memo field unless formatting has
been applied to the control or the query is using GroupBy or DISTINCT.
 
Back
Top