Hi,

Something like this should do it:

INSERT INTO [dbo].[mp_LetterSubscribe]

(

[SiteGuid],

[LetterInfoGuid],

[UserGuid],

[Email],

[IsVerified],

[VerifyGuid],

[BeginUtc],

[UseHtml],

IpAddress

)

SELECT DISTINCT

li.SiteGuid,

li.LetterInfoGuid,

u.UserGuid,

u.Email,

1,

'00000000-0000-0000-0000-000000000000',

GetUtcDate(),

1,

''

FROM

mp_LetterInfo li

CROSS JOIN

mp_Users u

WHERE

u.UserGuid NOT IN (SELECT ls.UserGuid FROM mp_LetterSubscribe ls WHERE ls.LetterInfoGuid = li.LetterInfoGuid)

ORDER BY u.Email

Also, if it would help I can put up an interim build on our Novell Forge download page that includes the fix for this. Just let me know.

Best,

Joe

Hi,

fyi, I put up an interim build for MS SQL on our Novell Forge Download page mojoportal-build-2009-11-22-mssql.zip which has the fix for both the ldap users not getting the default newsletters and also the fix for if users change their email address so it stays in sync in the newsletters.

Best,

Joe