Macro to save object

  • Thread starter Thread starter Rob
  • Start date Start date
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
 
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
 
Sorry the correct syntax for the output to for a filename of
c:\testjobs112103.rtf
is
="C:\testjobs" & Format(Date(),"mmddyy") & ".rtf"

Jim
 
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...
 
Back
Top