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

E-mail problems - mailtolist help needed

Status
Not open for further replies.

ddamsgaard

Technical User
Jun 30, 2003
12
0
0
I have a VB program that e-mails reports. The main portion sends 300 or so e-mails, one at a time. Then I e-mail the entire report to me.

So far, so good. Everything works.

Now I want to add a second e-mail address to the final report. When I do this, the procedure crashes at the Export False statement.

Here's the code:

With crxReport
.ExportOptions.DestinationType = crEDTEMailMAPI
.ExportOptions.MailSubject = "Crystal Reports - Testing Email; pls delete"
.ExportOptions.MailMessage = "This is a test - disregard."
.ExportOptions.MailToList = "dennis_d@abcd1234.com"
.ExportOptions.FormatType = crEFTPortableDocFormat
.Export False
End With

As noted, the above works.

But when I try to add an address like this:

.ExportOptions.MailToList = "dennis_d@abcd1234.com, jack_j@xyz.com"

the Export False fails with "Failed to export the report".

I can't find how to format this parameter. Is there some other parameter I should be using?

Thanks in advance.
 
It looks like the ";" is the separator to use between addresses. I thought I'd tried this before, but perhaps not.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top