Forums :: Advanced Mail :: DwZone Forum

DwZone Forum
Welcome to the DwZone-it Forum

FAQ

Memberlist

Usergroups

Advanced Mail

DwZone Forum Index -> Advanced Mail

Moderators: Administrators, Moderators

Mark all topics read

Hint: For improved responsiveness, use Internet Explorer 4 (or above) with Javascript enabled, choose 'Dynamic' from the View dropdown and hit 'Set Options' to save your changes.

	Search for
View Per page Messages Since

Messages 71 to 80 of 781 (Total: 224)

First | Prev | Next | Last

Subject

Author

Date

Cannot send e-mail if the clause WHERE is present

[email protected]

10:54 30 Mar 2010

Hi Gianluigi
The Advanced Mail cannot send any e-mail to a mailing list if the clause "WHERE" is present.
For instance, I have the following query using your query manager:

"SELECT dbo.MailingList.Name, dbo.MailingList.Email, dbo.MailingList.SubscribeFlag FROM dbo.MailingList WHERE (((dbo.MailingList.SubscribeFlag)='" & Y & "'))"

I have list of three e-mails in my table and I only want to send an e-mail to the ones that have the SubscribeFlag=Y. Two of them have that flag set to Y and one is set to N.
Even when I test my query using your query manager, it shows all three records although the query is restricted to the ones that have the Y flag.

As soon as I remove the clause "WHERE" with everything that's coming after, and I save my document, I can send e-mails to the whole distribution list.

Can I get some understanding here... maybe I am not doing something right?
I am running Advanced Mail version 2.4.5

Thanks
Adrian