Excel Com Handles in Progress

D

dougfl

New Member
I am using progress to create a spreadsheet that I e-mail to different receipients. The problem come when I try to send to multiple receipients. No matter how I load the information into the 'lc-email-address' variable I cannot get it to handle more then one. Can anyone out there give me any guidance on this?

Below is the line of code I am using to send the e-mail.

lc-email-address (char) holds the reciepients

lc-subject (char) holds the subject line

ll-read-rec (logical) holds whether the sender wants to have a read reciept.

chWorkBook:SendMail(lc-email-address,lc-subject,ll-read-rec) no-error.
 
The problem is that sendmail expects the recipients as an array of recipients. In VBA the macro to send email to multiple recipients would look something like this:

Sub sendingmail()
Dim a(2)
a(1) = "receiver1@mail.com"
a(2) = "receiver2@mail.com"
ThisWorkbook.SendMail (a)

End Sub


However, a progress extent does not match the VB array datatype so it is not possible to simple put the addresses in an variable with an extent and pass this to the sendmail method.

I think the best option would be to create a macro in excel to build an array of recipients based upon a comma seperated string that you pass to this macro and that this macro also invokes the sendmail method.

I hope this will get you a little further.
 
so you can send email via excel? I have this low priority job right now once i get bigger things done. And the way i had it was save the excel file to a temp-dir then run a outlook comhandle that send this all out. i might have to look into this.
 
You must log in or register to reply here.
Back
Top