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 strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Can this be done in CR 9.0?

Status
Not open for further replies.

52

Programmer
Jan 23, 2002
30
US
I'm looking to e-mail a report once a month to several people (and would like this to be automated). Do I need Enterprise for this or is there a way to write a program that will do this for me?

Thanks!!
 
You can code it using VB or most 3rd party applications, the question is whether it's worth it.

You can also use a third party scheduler, check:


Or you might use a Windows macro recorder and use a scheduler program to set up a cheapo solution.

-k
 
From within VB here's how I do it and I have version 9.0 Developer.

crMyReport.DestinationType = crEDTEMailMAPI
crMyReport.ExportOptions.MailToList = "SomeOne@SomeWhere.com"
crMyReport.ExportOptions.MailCcList = "SomeOneElse@ SomeWhere.com"
crMyReport.ExportOptions.MailSubject = "Here’s You Report”
crMyReport.ExportOptions.MailMessage = "Attached is a your report. "
crMyReport.ExportOptions.FormatType = crEFTWordForWindows
crMyReport.Export False


Good luck
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top