Need help Export Reports with MAPI .

[jameslx]

Is there a way to Export reports through Outlook with out Outlook being open. This is a VB Script program running through WScript. The program reads a SQL file and gets the parameters for ExportOptions.MailCcList, ExportOptions.MailMessage, ExportOptions.MailSubject, and ExportOptions.MailToList and these work fine as long as you keep Mail open. Is there a Parameter I can use to open or set the Mail Profile. Any Sugestions. I set the fields in the code below.

Set ExportOptions = crReport.ExportOptions
If ExD = 2 then
'	wscript.echo ExF,ExFN
	ExportOptions.FormatType = Cint(ExF)
	'Format Type 
        ExportOptions.DiskFileName = ExFN 
	' Disk File Name
	ExportOptions.DestinationType = Cint(ExD) 
	' Destination type       '2  'crEDTEMailMAPI
	crReport.ExportOptions.MailCcList = txtCCList
	crReport.ExportOptions.MailMessage = txtMessage
	crReport.ExportOptions.MailSubject = txtSubject
	crReport.ExportOptions.MailToList = txtToList
End If
' Export the report and set the export prompting parameter to false

 

[dgillz]

James-

Not sure if you are interested but check out

http://www.chelseatech.co.nz.

He has written a UFL for crystal reports that allows crystal to generate an email when the report is generated, regardless if Outlook is open or not.

At best, his product could be an easy solution for oyu and at worst he may be able to give you some answers as his entire UFL is based on MAPI compliant products.

Good Luck Software Support for Sage Mas90, Macola, Crystal Reports, Goldmine and MS Office

 

[jameslx]

dgilz: Thanks, I will try the address and find out what I can do. At this point any help will do.