Send object but add date first

H

Hal239

Hi,
I'm trying to send results from a query via email but I want to add today's
date on the file name first. Can anyone help? I'm using Access 2003.
Thanks, Hal
 
S

Steve Schapel

Hal,

I don't think you can control the file name when using SendObject. You
could, however, have the macro automatically write the current date into the
Subject header of the email.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Condition for Send object 1
Include today's date in csv file name 3
Asset Management - PC Birth Date 11
Send object function with a CSV file 4
SendObject subject line with field names 1
How to Use Field Twice in Query 1
Macro conditions to open a query 2
Access Access send object 0

Top