K
KC Classic
I have a simple Access report captioned "ARK252 Balancing" that is currently
e-mailed manually on a daily basis. Under the current process, we would
export the report in .rtf format and rename manually using the most recent
date in the [SS DATE] field in one of the tables. For example, the report
Caption currently reads "ARK252 Balancing 06202007.rtf".
I have used the SendObject action in a macro to generate and attach the
report to the e-mail recipients in the .rtf format automatically to eliminate
this manual process. Can the Caption of the report (which I have learned
flows through to the report title generated in Access) incorporate the most
recent date from the [SS DATE] field f? If so, can someone provide an
example of the SQL required to make this happen?
Any suggestion are greatly appreciated.
Thank you in advance,
KC Classic
e-mailed manually on a daily basis. Under the current process, we would
export the report in .rtf format and rename manually using the most recent
date in the [SS DATE] field in one of the tables. For example, the report
Caption currently reads "ARK252 Balancing 06202007.rtf".
I have used the SendObject action in a macro to generate and attach the
report to the e-mail recipients in the .rtf format automatically to eliminate
this manual process. Can the Caption of the report (which I have learned
flows through to the report title generated in Access) incorporate the most
recent date from the [SS DATE] field f? If so, can someone provide an
example of the SQL required to make this happen?
Any suggestion are greatly appreciated.
Thank you in advance,
KC Classic