Community
Showing results for 
Search instead for 
Do you mean 
Reply

Add Mail merge field to DOC/ADT template a field OLE label is incorrect

JM
Nickel Contributor
Posts: 584
Country: USA

Add Mail merge field to DOC/ADT template a field OLE label is incorrect

[ Edited ]

ACT! Prem 2010, 12.1.181.0  SP1 HF4, on Win7 Home 64bit, using Office Pro Word 2007.

I must have corruption related to OLE somewhere because even after a Save-Empty copy DB import from Old DB into new one problem is still there.  When from ACT! Add-in, Add a Contact Mail Merge Field labled as "Address 3_B" it is the defined field name in ACT fields.  When I select form drop down the labled name "Address 2_B" and insert into DOC the field label name is also "Address 3_B" but is merging data from the Address 2B field.

 

ACTDIAG Field report shows:

----------------------------------------------------------------------------------------------------
     ACT! Field: Address 2_B                                       ACT! Fieldtype: Character(256)
Physical Column: BUSINESS_LINE3                                 Physical Datatype: NVARCHAR(256)
  OLE/DB Column: CONTACT Address 3_B
OLEDB(2) Column: [CONTACT].[ADDRESS_3]
          Alias: ADDRESS_3
  Created On/By: May  3 2006  1:09AM / ACT! System
         Custom: 0    Displayed: 1    Define Fields: 1    Ordinal:    
   Allow Blanks: 1      Primary: 1   Record History: 0
      Protected: 0   Can Resize: 0       Can Delete: 0
 Default Access: FULL ACCESS (2)    Valid Access Levels: 7 (NA RO FA)
    Access List: All Users(2)

----------------------------------------------------------------------------------------------------
     ACT! Field: Address 3_B                                       ACT! Fieldtype: Character(256)
Physical Column: BUSINESS_LINE2                                 Physical Datatype: NVARCHAR(256)
  OLE/DB Column: CONTACT Address 2_B
OLEDB(2) Column: [CONTACT].[ADDRESS_2]
          Alias: ADDRESS_2
  Created On/By: May  3 2006  1:09AM / ACT! System
         Custom: 0    Displayed: 1    Define Fields: 1    Ordinal:    
   Allow Blanks: 1      Primary: 1   Record History: 0
      Protected: 0   Can Resize: 0       Can Delete: 0
 Default Access: FULL ACCESS (2)    Valid Access Levels: 7 (NA RO FA)
    Access List: All Users(2)

 

Any way to correct this and I think should fix it before upgrading to 2011?

I have done complete ACTDIAG rebuilds and repairs.

JM

Bronze Contributor
Posts: 955
Country: Australia

Re: Add Mail merge field to DOC/ADT template a field OLE label is incorrect

I would be inclined to upgrade and then relook at the problem as I believe it may be in the integration not necessarily in the database

Paul Buchtmann
pbuchtmann@ozemail.com.au Australia
Australia's First ACT Consultant (1989)

FREE Record History to change default to Call or To-Do for ACT! 2010-2012 versions. Custom versions also available.
JM
Nickel Contributor
Posts: 584
Country: USA

Re: Add Mail merge field to DOC/ADT template a field OLE label is incorrect

upgrade had no effect.

jm