[Resolved] [2005] Call Outlook with attachment

snufse · February 11th, 2008, 10:05 AM

I have a vb application that displays a Crystal Report (using CrystalReportViewer). User would like to open outlook with the Crystal Report as an attachment and select receipients.

I have the shell command that opens outlook

Code:

dblRetVal = Shell("C:\Program Files\Microsoft Office\Office12\OUTLOOK.EXE", vbMaximizedFocus)

but I am not sure if it is possible to include an attachement

samjudson · February 11th, 2008, 10:47 AM

http://office.microsoft.com/en-us/ou...031101033.aspx

outlook /a "file.doc"

/- Sam Judson : Wrox Technical Editor -/

snufse · February 11th, 2008, 01:49 PM

So, can I do it like this?

Code:

dblRetVal = Shell("C:\Program Files\Microsoft Office\Office12\OUTLOOK.EXE" + "/a" + """ + CrystalReportViewer1 + """ + ")", vbMaximizedFocus)

Not sure if I can attach a CrystalReportViewer as a document.

samjudson · February 11th, 2008, 06:15 PM

No you can't - you would have to save the Crystal report to a file (PDF would be my most likely suggestion) and attach that. I'm sure Crystal reports comes with functionality like that.

Also if you use the System.Diagnostics.Process class, as it provide functionality for starting processes with arguments.

/- Sam Judson : Wrox Technical Editor -/

snufse · February 12th, 2008, 09:59 AM

OK, Crystal Report has an option to export a view to a .pdf file. I will try to use that. Thank you.