Have you confirmed that the view contains the custom field?

As the system was upgraded and the mail merge draws its data from 'system' views, these may have been reset during the upgrade process.

The field "comp_wf_agente" needs to be contained in the following database views

Hi Jeff,

Confirm, the view contains the custom field: postimg.org/.../hsplft2lx

I can send you the template we use to observe as we introduce the tags «TableStart:Quotes» «TableEnd:Quotes» and custom field and this does not appear.

thanks,

Regards.

HiJeff,

We have modified the SQL views on database CRM to add the custom field but still does not appear to perform merge.

Thanks,

Regards.

I can not reproduce this. I am using Sage CRM 7.3 sp3

On my system I added a new field to the company table "comp_testfield". I then added it to the companyboxlong screen and made sure that there was data stored in it for the Gatecom demo company. I then changed the company mail merge view vMailMergeCompany to include "comp_testfield".

I could then select the field for inclusion in a new HTML mail merge template.

I think you need to log a case with the local Sage team.

Hi Jeff,

Thanks for your help.

You could give me an example of template for Microsoft Word with you employ tags to display the custom field ?

It's possible that the problem is with tags for Microsoft Word.

Thanks;

Regards.

Any suggested fixes to this problem?

Lisa

The two most important aspects of working with a custom field for mail merge is that the field must be included in the underlying view.

community.sagecrm.com/.../sage-crm-7-2-how-mail-merge-works.aspx

When editing the templates in Word you then need to use the Quick Part feature of Word to manually add the field you want into the template to be used fort Sage CRM.

Please see: community.sagecrm.com/.../working-with-the-mail-merge-feature-in-sage-crm-cloud-2012-r2.aspx