RabSwinney
Technical User
How can I set up a macro to send a report on the first day of each month?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Auto E.mail
- Thread starter RabSwinney
- Start date
- Status
TravisHarris
Programmer
1. Create a Macro
2. Use the SendObject action and set up the arguments as desired.
Example:
Object Type: Report
Object Name: Name of Report
Output Format: Choose your preferred format
To: Enter the chosen email address(es)
CC: same as above
BCC: same as above
Subject: Subject line for your email
Message Text: Whatever text you want in addition to report
Edit Message: pick yes if you want to edit, or see message before it is sent. Pick no if you want it to go without any interaction.
3. Run the macro (I usually put a button on a form to run the macro).
-Travis
2. Use the SendObject action and set up the arguments as desired.
Example:
Object Type: Report
Object Name: Name of Report
Output Format: Choose your preferred format
To: Enter the chosen email address(es)
CC: same as above
BCC: same as above
Subject: Subject line for your email
Message Text: Whatever text you want in addition to report
Edit Message: pick yes if you want to edit, or see message before it is sent. Pick no if you want it to go without any interaction.
3. Run the macro (I usually put a button on a form to run the macro).
-Travis
- Thread starter
- #3
RabSwinney
Technical User
Thanks for that Travis, Can I set it up to Auto email itself on the first day of ever month?
- Status
Similar threads
- Locked
- Question