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...
 
You must log in or register to reply here.

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

How can we convert OST to PDF file format? 1
Macro to run from a form and save to rtf files 1
How to avoid having to click Allow each time 2
Word Macro to insert text and save as PDF 4
Send Object (Access 2003) 1
Send Object Macro 3
Outlook Looking for macro to save multiple emails as .msg to folder and extracting the invoice ref. from the email body as the filename 4
How do I use table data as a variable in a macro query 4

Back
Top