I’m trying to send an email via dataease. Over all this is a very useful function, but my goal is to send an email to many recipients and  the “send” command use simply a string with a limitation of 255 characters that don’t fit all the recipients. Even if I tried to change “To” field using Memo I cannot send my mail to all recipients.

How can I solve this problem? Have You any suggestion for this? Thanks.

It is a problem that functions cannot take longer arguments than 255 in DataEase, but not one that there is any easy way around.

Both email functions in DE8.x is "third party" and we have scheduled a built in function for some time but as the third party versions cover most use cases it is not a priority.

Both functions can of course send to multiple addresses but as you have pointed out the 255 kind of limit this very quickly.

In my mind this isn't a problem, and before you jump at me let me explain ;-)

I automatically disregard multi-addresses emails as "SPAM" i.e. not to me.

Most email software don't have a  send an email individually to each person so you end up including everyone on the address line and by then sharing everyone email with each other when at the same time giving the impression that this is not directed to any given person.

A way around this of course is to send the email to oneself and include everyone else as BCC.

When you have DataEase send the email for you, you can simply run a loop and send an email to each person and also adept it to fit each person by giving it a personal greeting;

Hello [{firstname}]

etc.

So the way around this problem is to simply loop the send function.

Thank you for your reply. I know that it's not an error. I wrote into the forum only for a suggestion. Anyway  in the meantime I found an alternative solution. I mean 

1) Create a .cmd file using the complete syntax of blat command using MemoWriteToFile in order to fill the recipients list .

2) Launch the command via Shellexecute

Here the content of the .cmd file

blat -to

user1@atradius.com,user2@atradius.com,user3@atradius.com,user4@atradius.com,user5@atradius.com,user6@atradius.com,user7@atradius.com,us

er8@atradius.com,user9@atradius.com,user10@atradius.com,user11@atradius.com,user12@atradius.com,user13@atradius.com,user14@atradius.com

, <.....etc> -html -subject Email subject -bodyf "W:\<DB directory>\mail\00001.html"

To be honest, that too was on my mind but for you to come up with is creative and elegant, for me to suggest it sound like we are asking you to make your own product ;-)

So you get all the credit ;-)