10-29-2010 03:41 PM
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
11-02-2010 11:41 AM
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