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!

Administration Forums - General Administration
Forum to discuss general administration topics for SalesLogix (including LAN & remote topics). View the code of conduct for posting guidelines.

Forums RSS Feed

Back to Forum List | Back to General Administration | New Thread

View: Search:

Author

Thread: Mail merge issue

Todd Daskal
Posts: 31

Mail merge issue Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 25 Feb 08 4:27 PM

Has anyone seen this message
"Mail Merge Engine encountered an error and cannot continue. The address table query is empty.

[Reply][Quote]

Phil Parkin
Posts: 819

Re: Mail merge issue Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 25 Feb 08 7:39 PM

Yes - it happens when you have Contacts/Accounts with no Primary address.

[Reply][Quote]

Phil Parkin
Posts: 819

Re: Mail merge issue Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 25 Feb 08 8:56 PM

Here's some SQL that might help you out.

select a.accountid, a.account
from account a
where not exists (select addr.addressid from address addr where addr.entityid = a.accountid and addr.isprimary = 'T')

Works for accounts - modify it a little and it will work for contacts too.

PP

[Reply][Quote]

Todd Daskal
Posts: 31

Re: Mail merge issue Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 26 Feb 08 12:31 AM

Cool...thanks

[Reply][Quote]

Todd Daskal
Posts: 31

Re: Mail merge issue Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 26 Feb 08 12:45 PM

Thanks Phil, the SQL works great, the suspect record is not part of the result. Any other ideas?

Thanks!

[Reply][Quote]

Martin Rudnick
Posts: 52

Re: Mail merge issue Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 27 Feb 08 8:28 AM

Have you checked whether there are any single quotes/apostrophes in the addresses? That can end up being a gotcha on SQL queries involving addresses. Another thing to check could be the use of a calculated field for the address-city-st-zip if you are applying a group.

[Reply][Quote]

Todd Daskal
Posts: 31

Re: Mail merge issue Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 27 Feb 08 11:08 AM

Hi Phil, issue is resolved with your help!

[Reply][Quote]

Phil Parkin
Posts: 819

Re: Mail merge issue Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 27 Feb 08 2:14 PM

Excellent, no problem!

[Reply][Quote]

John Gundrum
Posts: 632

Re: Mail merge issue Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 21 Jan 09 1:25 PM

Ah, excellent. I had the same problem and discovered with the help of this post that the contact's address was not marked as primary (or shipping)

[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 © 2024 Customer FX Corporation. The information and opinions expressed here are not endorsed by Sage Software.	code of conduct \|

page cache (param): 11/26/2024 1:47:30 PM