Hello,
I am writing an excel macro that converts the excel sheet in a pdf and then emails the pdf to a predefined list of recipients. The list of recipients is contained in one the excel cell. The email is sent using with Lotus using the csendmail sub function (but this is not supposed to be a problem).
The problem I have is the following: it looks like that the cell containing the mailing list has too many characters for csendmail, the beginning of the list is correctly copied in the Lotus recipients field but it's truncated after a while, so the whole list is not copied in the field. I guess it comes from the fact that in csendmail the Recipients attribute is a String type so it's limited ton 255 characters. Does anyone has an idea on how to bypass that ?
Thanks