slxdeveloper.com Community Forums

The Forums on slxdeveloper.com are now retired. The forum archive will remain available for the time being. Thank you for your participation on slxdeveloper.com!

Web Forums - SalesLogix Web Platform & Application Architect
Forum to discuss the use of the SalesLogix Web Platform, Client and Customer Portals, and the Application Architect (For version 7.2 and higher only). View the code of conduct for posting guidelines.

Forums RSS Feed

Back to Forum List | Back to SalesLogix Web Platform & Application Architect | New Thread

View: Search:

Author

Thread: Web Mail Merge Error - No contacts exist in selected Group.

Jose Urena
Posts: 92

Web Mail Merge Error - No contacts exist in selected Group. Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 18 Sep 09 9:52 AM

Hey i have a new problem with mail merge... it opens, allows me to search the list of merge documents, but when i try to count or do the merge, then i get the error "Unable to run Mail Merge. No contacts exist in selected Group." and cannot run MM on Web... If i use the same group on LAN then it works well... If i do the merge on a single account or contact it works well...

I've tryed creating a single account/contact group and get the same error.

I really need help with this issue because i can lose a good contract.

[Reply][Quote]

Jose Urena
Posts: 92

Re: Web Mail Merge Error - No contacts exist in selected Group. Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 06 Oct 09 11:10 AM

Anybody? Ryan? I don't see where to troubleshoot this... i used the Fidler and what i get when press the "COUNT" button is:

HTTP/1.1 200 OK
Server: Microsoft-IIS/5.1
Date: Tue, 06 Oct 2009 16:12:11 GMT
X-Powered-By: ASP.NET
X-AspNet-Version: 2.0.50727
Cache-Control: private
Expires: Tue, 06 Oct 2009 16:11:10 GMT
Content-Type: text/html; charset=utf-8
Content-Length: 9172

<?xml version="1.0" encoding="UTF-16"?><SLXGroup><plugindata id="pDEMOA0000M4" name="Cartera por Cobrar a 30 " displayname=" Por Cobrar a 30 días Triple Pack" family="Account" type="8" system="" userid="NDEMOA000023" /><groupid>pDEMOA0000M4</groupid><description></description><layouts count="8" maintable="ACCOUNT"><layout><datapath><![CDATA[ACCOUNT:NUMCTA]]></datapath><alias><![CDATA[NUMCTA]]></alias><displayname><![CDATA[NUMCTA]]></displayname><displaypath>Account</displaypath><fieldtype>1</fieldtype><caption><![CDATA[NUMCTA]]></caption><width>100</width><align>Left</align><captalign>Left</captalign><format>None</format><formatstring><![CDATA[]]></formatstring><weblink>F</weblink><cssclass></cssclass><visible>T</visible></layout><layout><datapath><![CDATA[ACCOUNT:ACCOUNT]]></datapath><alias><![CDATA[ACCOUNT]]></alias><displayname><![CDATA[Account]]></displayname><displaypath>Account</displaypath><fieldtype>1</fieldtype><caption><![CDATA[Account]]></caption><width>180</width><align>Left</align><captalign>Left</captalign><format>None</format><formatstring><![CDATA[]]></formatstring><weblink>F</weblink><cssclass></cssclass><visible>T</visible></layout><layout><datapath><![CDATA[ACCOUNT:NOMCOMERCIAL]]></datapath><alias><![CDATA[NOMCOMERCIAL]]></alias><displayname><![CDATA[NOMCOMERCIAL]]></displayname><displaypath>Account</displaypath><fieldtype>1</fieldtype><caption><![CDATA[NOMCOMERCIAL]]></caption><width>120</width><align>Left</align><captalign>Left</captalign><format>None</format><formatstring><![CDATA[]]></formatstring><weblink>F</weblink><cssclass></cssclass><visible>T</visible></layout><layout><datapath><![CDATA[ACCOUNT:COND_PAGO]]></datapath><alias><![CDATA[COND_PAGO]]></alias><displayname><![CDATA[COND_PAGO]]></displayname><displaypath>Account</displaypath><fieldtype>1</fieldtype><caption><![CDATA[COND_PAGO]]></caption><width>120</width><align>Left</align><captalign>Left</captalign><format>None</format><formatstring><![CDATA[]]></formatstring><weblink>F</weblink><cssclass></cssclass><visible>T</visible></layout><layout><datapath><![CDATA[ACCOUNT:FORMA_PAGO]]></datapath><alias><![CDATA[FORMA_PAGO]]></alias><displayname><![CDATA[FORMA_PAGO]]></displayname><displaypath>Account</displaypath><fieldtype>1</fieldtype><caption><![CDATA[FORMA_PAGO]]></caption><width>120</width><align>Left</align><captalign>Left</captalign><format>None</format><formatstring><![CDATA[]]></formatstring><weblink>F</weblink><cssclass></cssclass><visible>T</visible></layout><layout><datapath><![CDATA[ACCOUNT:LIMITE_CR]]></datapath><alias><![CDATA[LIMITE_CR]]></alias><displayname><![CDATA[LIMITE_CR]]></displayname><displaypath>Account</displaypath><fieldtype>6</fieldtype><caption><![CDATA[LIMITE_CR]]></caption><width>120</width><align>Right</align><captalign>Left</captalign><format>None</format><formatstring><![CDATA[]]></formatstring><weblink>F</weblink><cssclass></cssclass><visible>T</visible></layout><layout><datapath><![CDATA[ACCOUNT:TIPOENTIDAD]]></datapath><alias><![CDATA[TIPOENTIDAD]]></alias><displayname><![CDATA[TIPOENTIDAD]]></displayname><displaypath>Account</displaypath><fieldtype>1</fieldtype><caption><![CDATA[TIPOENTIDAD]]></caption><width>120</width><align>Left</align><captalign>Left</captalign><format>None</format><formatstring><![CDATA[]]></formatstring><weblink>F</weblink><cssclass></cssclass><visible>T</visible></layout><layout><datapath><![CDATA[ACCOUNT:ACCOUNT]]></datapath><alias><![CDATA[ACCOUNT]]></alias><displayname><![CDATA[Account]]></displayname><displaypath>Account</displaypath><fieldtype>1</fieldtype><caption><![CDATA[Account]]></caption><width>1</width><align>Left</align><captalign>Left</captalign><format>None</format><formatstring><![CDATA[]]></formatstring><weblink>F</weblink><cssclass></cssclass><visible>F</visible></layout></layouts><conditions count="8"><condition><datapath><![CDATA[ACCOUNT:SLD_RANGO1]]></datapath><alias><![CDATA[A1.SLD_RANGO1]]></alias><displayname><![CDATA[SLD_RANGO1]]></displayname><displaypath><![CDATA[Account]]></displaypath><fieldtype>6</fieldtype><operator><![CDATA[<>]]></operator><value><![CDATA[0]]></value><connector><![CDATA[AND]]></connector><leftparens><![CDATA[]]></leftparens><rightparens><![CDATA[]]></rightparens><isliteral>false</isliteral><isnegated>false</isnegated><casesens>true</casesens></condition><condition><datapath><![CDATA[ACCOUNT:SLD_RANGO2]]></datapath><alias><![CDATA[A1.SLD_RANGO2]]></alias><displayname><![CDATA[SLD_RANGO2]]></displayname><displaypath><![CDATA[Account]]></displaypath><fieldtype>6</fieldtype><operator><![CDATA[=]]></operator><value><![CDATA[0]]></value><connector><![CDATA[AND]]></connector><leftparens><![CDATA[]]></leftparens><rightparens><![CDATA[]]></rightparens><isliteral>false</isliteral><isnegated>false</isnegated><casesens>true</casesens></condition><condition><datapath><![CDATA[ACCOUNT:SLD_RANGO3]]></datapath><alias><![CDATA[A1.SLD_RANGO3]]></alias><displayname><![CDATA[SLD_RANGO3]]></displayname><displaypath><![CDATA[Account]]></displaypath><fieldtype>6</fieldtype><operator><![CDATA[=]]></operator><value><![CDATA[0]]></value><connector><![CDATA[AND]]></connector><leftparens><![CDATA[]]></leftparens><rightparens><![CDATA[]]></rightparens><isliteral>false</isliteral><isnegated>false</isnegated><casesens>true</casesens></condition><condition><datapath><![CDATA[ACCOUNT:SLD_RANGO4]]></datapath><alias><![CDATA[A1.SLD_RANGO4]]></alias><displayname><![CDATA[SLD_RANGO4]]></displayname><displaypath><![CDATA[Account]]></displaypath><fieldtype>6</fieldtype><operator><![CDATA[=]]></operator><value><![CDATA[0]]></value><connector><![CDATA[AND]]></connector><leftparens><![CDATA[]]></leftparens><rightparens><![CDATA[]]></rightparens><isliteral>false</isliteral><isnegated>false</isnegated><casesens>true</casesens></condition><condition><datapath><![CDATA[ACCOUNT:SLD_RANGO5]]></datapath><alias><![CDATA[A1.SLD_RANGO5]]></alias><displayname><![CDATA[SLD_RANGO5]]></displayname><displaypath><![CDATA[Account]]></displaypath><fieldtype>6</fieldtype><operator><![CDATA[=]]></operator><value><![CDATA[0]]></value><connector><![CDATA[AND]]></connector><leftparens><![CDATA[]]></leftparens><rightparens><![CDATA[]]></rightparens><isliteral>false</isliteral><isnegated>false</isnegated><casesens>true</casesens></condition><condition><datapath><![CDATA[ACCOUNT:SLD_RANGO6]]></datapath><alias><![CDATA[A1.SLD_RANGO6]]></alias><displayname><![CDATA[SLD_RANGO6]]></displayname><displaypath><![CDATA[Account]]></displaypath><fieldtype>6</fieldtype><operator><![CDATA[=]]></operator><value><![CDATA[0]]></value><connector><![CDATA[AND]]></connector><leftparens><![CDATA[]]></leftparens><rightparens><![CDATA[]]></rightparens><isliteral>false</isliteral><isnegated>false</isnegated><casesens>true</casesens></condition><condition><datapath><![CDATA[ACCOUNT:SLD_RANGOPLUS]]></datapath><alias><![CDATA[A1.SLD_RANGOPLUS]]></alias><displayname><![CDATA[SLD_RANGOPLUS]]></displayname><displaypath><![CDATA[Account]]></displaypath><fieldtype>6</fieldtype><operator><![CDATA[=]]></operator><value><![CDATA[0]]></value><connector><![CDATA[AND]]></connector><leftparens><![CDATA[]]></leftparens><rightparens><![CDATA[]]></rightparens><isliteral>false</isliteral><isnegated>false</isnegated><casesens>true</casesens></condition><condition><datapath><![CDATA[ACCOUNT:ACCOUNTID>ACCOUNTID.DOCUMENTOS!SUB_TIPO]]></datapath><alias><![CDATA[A2.SUB_TIPO]]></alias><displayname><![CDATA[Sub_Tipo]]></displayname><displaypath><![CDATA[Account.Documentos]]></displaypath><fieldtype>1</fieldtype><operator><![CDATA[=]]></operator><value><![CDATA[:ValueParam0]]></value><connector><![CDATA[END]]></connector><leftparens><![CDATA[]]></leftparens><rightparens><![CDATA[]]></rightparens><isliteral>false</isliteral><isnegated>false</isnegated><casesens>true</casesens></condition></conditions><sorts count="1"><sort><datapath><![CDATA[ACCOUNT:ACCOUNT]]></datapath><alias><![CDATA[ACCOUNT_UC]]></alias><displayname><![CDATA[Account]]></displayname><displaypath><![CDATA[Account]]></displaypath><sortorder>ASC</sortorder></sort></sorts><hiddenfields count="1"><hiddenfield><datapath><![CDATA[ACCOUNT:ACCOUNTID]]></datapath><alias><![CDATA[ACCOUNTID]]></alias><displayname><![CDATA[Accountid]]></displayname><displaypath><![CDATA[Account]]></displaypath><fieldtype>23</fieldtype></hiddenfield></hiddenfields><parameters><parameter><name><![CDATA[ValueParam0]]></name><datatype>string</datatype><value><![CDATA[S4]]></value></parameter></parameters><selectsql><![CDATA[A1.ACCOUNTID, A1.NUMCTA, A1.ACCOUNT, A1.NOMCOMERCIAL, A1.COND_PAGO, A1.FORMA_PAGO, A1.LIMITE_CR, A1.TIPOENTIDAD, A1.ACCOUNT_UC]]></selectsql><fromsql><![CDATA[ACCOUNT A1 LEFT OUTER JOIN DOCUMENTOS A2 ON (A1.ACCOUNTID=A2.ACCOUNTID)]]></fromsql><wheresql><![CDATA[(A1.SLD_RANGO1<>0) AND (A1.SLD_RANGO2=0) AND (A1.SLD_RANGO3=0) AND (A1.SLD_RANGO4=0) AND (A1.SLD_RANGO5=0) AND (A1.SLD_RANGO6=0) AND (A1.SLD_RANGOPLUS=0) AND (A2.SUB_TIPO=:ValueParam0)]]></wheresql><orderbysql><![CDATA[A1.ACCOUNT_UC ASC]]></orderbysql><valuesql><![CDATA[]]></valuesql><maintable>ACCOUNT</maintable><adhocgroup>false</adhocgroup><adhocgroupid></adhocgroupid><adddistinct>false</adddistinct></SLXGroup>

It looks correct TO ME... but the same error: "Illegal assignment" box, and then the "Unable to run..." box.

[Reply][Quote]

Jose Urena
Posts: 92

Re: Web Mail Merge Error - No contacts exist in selected Group. Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 06 Oct 09 1:29 PM

I must say that this is with SLX 7.2.2 Web Client

[Reply][Quote]

Page 1 of 1

You can subscribe to receive a daily forum digest in your user profile. View the site code of conduct for posting guidelines.

Forum RSS Feed - Subscribe to the forum RSS feed to keep on top of the latest forum activity!

slxdeveloper.com is brought to you courtesy of Ryan Farley & Customer FX Corporation. This site, and all contents herein, are Copyright © 2025 Customer FX Corporation. The information and opinions expressed here are not endorsed by Sage Software.	code of conduct \|

page cache (param): 7/4/2025 10:23:23 AM