send email to found set

[LisaA]

I can successfully send email to a single user but I can not get the to successfully create new emails in Eudora when I choose the "use found set" option. Any suggestions?

[eremaut]

It should work if Eudora support multiple e-mail-names separated by a semicolon and space (sorry, don't know). The result from FM in the TO-field is normaly like this: paul@xxxx; erwin@xxxxx; lisa@xxxxx (etc ...)

But, don't use this option at all! The solution from FM will not work (as many other of there topics) with a large number of names since there's a limit in size that the TO-field of your email client can handle!

With MS Outlook this limit is 32K. Wow, you say? If you have to launche big e-mailings like we do, you will find FM and MS Outlook crashing on this. The trick is ...

Build the list yourself by going into a loop-script and concatenates the e-mail names with semicolon and spaces (from the found set) into a global field.

Check for size not bigger then 32K, if so stop the loop and send in pieces.

Send the mail using the global field as the TO-field.

So something like this (don't mind the syntax here):

gEmail_Cat = ""

Loop

.

.

gEmail_Concat = gEmail_Concat & "; " & E_Mail

(for the first record use: gEmail_Concat = E_Mail)

.

Exit Loop if [sub_Check_32K]

.

Goto next record

End Loop

.

Send Mail

Offcourse this will take some processing power/time, but in our case MS Outlook and FM is no longer crashing and so we keep the sales guys happy !

Erwin