Macro to save object

R

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
 
J

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
 
J

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
 
R

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

.
Click to expand...
 
Top