Macro to save object

[Rob]

Everyday I have to generate a report, save an archive of
it, and also e-mail it. I do have a macro that will e-mail
it for me.
What I want to do is have a macro that will: 1. convert
the report to .rtf format, 2. save the report to my folder
on the network. 3. name the saved report with the current
date, i.e. "12 Nov 03".
Thanks,
Rob

 

[Jim/Chris]

Create a macro with the following Actions
SendObject ' This will do the emailing
Output to ' this will save the objent to file

to save with todays date for the output file nam use

="C:\filename\" & Format(Date(),"ddmmyy") & ".rtf"

Jim

 

[Jim/Chris]

Sorry the correct syntax for the output to for a filename of
c:\testjobs112103.rtf
is
="C:\testjobs" & Format(Date(),"mmddyy") & ".rtf"

Jim

 

[Rob]

Thanks, it works perfectly.

-----Original Message-----
Sorry the correct syntax for the output to for a filename of
c:\testjobs112103.rtf
is
="C:\testjobs" & Format(Date(),"mmddyy") & ".rtf"

Jim

.