View Single Post
  #1   Report Post  
Mark V
 
Posts: n/a
Default Using Hyperlinks in Mail Merge IF...THEN...ELSE Statements

Trying to include hyperlinks in Mail Merge IF...THEN...ELSE statements to
have different hyperlinks appear in the resulting Mail Merge to Email based
on values in other Mail Merge fields. For instance, to have different
support or product hyperlinks appear for different recipients depending on
the version of OS or S/W that they are running.

Have tried a number of approaches including:
- Manually adding the hyperlinks within the IF...THEN...ELSE statement by
using CNTL-F9 and typing a complete HYPERLINK statement.
- Creating a hyperlink elsewhere in the document (formatted as desired with
Display Text, Screen Tip and Address) and pasting it into the
IF...THEN...ELSE statement.
- Creating formatted text and hyperlinks in a separate document and using an
INCLUDETEXT statement within the IF...THEN...ELSE statement to add this
document to the Mail Merge document

In each case, the hyperlink either doesn't appear or only the text of the
hyperlink appears.

Example:

Depending on the version of Office contained in the Mail Merge field
Office_Version, an IF...THEN...ELSE statement would be used to display a
message with relevant hyperlinks.

If Office_Version = "Office 2000", the message might display "Systems
running this version must upgrade to either Office XP or Office 2003.".

If Office_Version = "Office XP", the message might display "Systems running
this version must upgrade to Office 2003.".

Using the following IF...THEN...ELSE statement should, in theory accomplish
this, but doesn't:

{ IF { MERGEFIELD Office_Version } = "Office 2000" "Systems running this
version must upgrade to either { HYPERLINK
"http://www.microsoft.com/office/previous/xp/default.asp" } or { HYPERLINK
"http://www.microsoft.com/office/editions/prodinfo/default.mspx" }." "Systems
running this version must upgrade to { HYPERLINK
"http://www.microsoft.com/office/editions/prodinfo/default.mspx" }." }

I am using Microsoft Office Word 2003 (11.5604.5703) from Microsoft Office
Professional Edition 2003.

Any guidance would be appreciated.

Thanks, Mark