vtiger

[jt196]

Dear vTiger developers,
You may have noticed that I've posted a few topics on this matter. This is my final topic and I would appreciate some feedback on the issue.

Put simply, word mail merge does not work on contacts that do not have an account in their record. This is because the mail merge queries the database via the account table in the database.

I think it's part of this code in the modules/contacts/merge.php file (line 150):

inner join vtiger_crmentity on vtiger_crmentity.crmid = vtiger_contactdetails.contactid
inner join vtiger_contactaddress on vtiger_contactdetails.contactid = vtiger_contactaddress.contactaddressid
inner join vtiger_contactsubdetails on vtiger_contactdetails.contactid = vtiger_contactsubdetails.contactsubscriptionid
inner join vtiger_contactscf on vtiger_contactdetails.contactid = vtiger_contactscf.contactid
left join vtiger_contactdetails as contactdetailsContacts on contactdetailsContacts.contactid = vtiger_contactdetails.reportsto
left join vtiger_account as accountContacts on accountContacts.accountid = vtiger_contactdetails.accountid
left join vtiger_users on vtiger_users.id = vtiger_crmentity.smownerid
left join vtiger_account on vtiger_account.accountid = vtiger_contactdetails.accountid
left join vtiger_crmentity as crmentityAccounts on crmentityAccounts.crmid=vtiger_account.accountid
left join vtiger_accountbillads on vtiger_account.accountid=vtiger_accountbillads.accountaddressid
left join vtiger_accountshipads on vtiger_account.accountid=vtiger_accountshipads.accountaddressid
left join vtiger_accountscf on vtiger_account.accountid = vtiger_accountscf.accountid
left join vtiger_account as accountAccounts on accountAccounts.accountid = vtiger_account.parentid
left join vtiger_users as usersAccounts on usersAccounts.id = crmentityAccounts.smownerid
where vtiger_crmentity.deleted=0 and (crmentityAccounts.deleted <> 1) and vtiger_contactdetails.contactid in(".$mass_merge.")";


The ability to mail merge in this way would be a huge benefit to me and many others. I think this should give you a clear idea of what the problem is and how to solve it. If the final release of 5.03 is on its way then I think this should be a priority to fix.

Hope this is of some help....

[jt196]

Fantastic news, version 5.03 of vTiger eliminates this problem altogether. Looking forward to a fantastic release, guys. It'll be worth the wait.