Showing results for 
Search instead for 
Do you mean 
Community Home Request Access Read Blogs Share Your Ideas Search Community View My Settings
Reply
Avid Listener
Posts: 18
Registered: ‎04-02-2009

Mail Merge (Office 2007), Mail Merge hyperlink that includes SLX field data

Hopefully someone has gone down this road before meTrying to create a hyperlink in a mail merge that contains a SalesLogix ID as a parameterEnd result would be something like http://www.url.com?ID=SLXIDVALUE where SLXIDVALUE is the contactID from SalesLogix.

 

Adding a standard hyperlink from the Word menu results in a static hyperling like http://www.url.com?ID=<CONTACTID>.  I have found instructions for modifying the hyperlink mergefield as follows:

 

 { HYPERLINK { MERGEFIELD "Contact_Contactid" <SLXMergeField name="CONTACTID" calculate="false" formatType="0" formatString=""></SLXMergeField> } \* MERGEFORMAT }

 

but this still does not do the trick.  May have to resort to creating these outside of the standard SalesLogix mail merge process.

 

SLX 7.5 SP2, Office 2007

Employee
Posts: 629
Registered: ‎04-24-2009

Re: Mail Merge (Office 2007), Mail Merge hyperlink that includes SLX field data

Unfortunately, Microsoft Word does [not] make it easy to insert a MERGEFIELD in a HYPERLINK field (please see http://www.officekb.com/Uwe/Forum.aspx/word-mailmerge/15722/Nested-mergefield-in-hyperlinks-changes-...

 

However, you have complete control of the Microsoft Word document when using the Custom Mail Merge field type (inserted using the template editor).

 

[LAN]

SystemSmiley FrustratedLX Mail Merge OnCustomFieldName

 

  'Add a hyperlink to the document for the custom mail merge field named "INSERT_SOME_HYPERLINK"

  Select Case strFieldName
    Case "INSERT_SOME_HYPERLINK"
      Dim sUrl
      sUrl = "http://www.test.com/default.aspx?ContactId=" & strContactID
      oRange.Hyperlinks.Add oRange, sUrl, "", "Screen Tip", "Please click here."

 

[Web]

In 7.5.2 you can edit the MailMerge.vbs to do the same (search for Sub MailMergeEngine_OnCustomFieldName).

 

Thanks

 

Mike