Windows Forum

Ask something
Discussion Locked

E-mailing Access report?

0 helpful
5 replies

by seamus

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

Here is my question. I created a report using access and it looks fine when I preview and print the report. However one of the major functions that I was asked to put in was, to allow it to be e-mailed. I have it emailing. However there is one date field that does not want to cooperate. If the date
on the report is 06-15 the date in the email will be -06-1. What can I do to fix this. I am saving it in an excel format, if that is any help.

5 replies

by corky132

Change the format of the date to include the year (either 06-22-2000 or 5-June-2000). This should take out the inconsistencies.

by cryingdragon

Here's an easy fix:

Create a new macro. In the settings,
choose send object, choose the report
you want, and the format you want it
emailed in, ie excel, html, txt

You can also set Subject, To:, CC: and
message fields in this.

Mike

This discussion is closed to new replies.