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

[smallbeck]

Hopefully someone has gone down this road before me.  Trying to create a hyperlink in a mail merge that contains a SalesLogix ID as a parameter.  End 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

[mcessna]

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]

SystemLX 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