Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Mail merge - Word 2003/Access 2000 | Mailmerge | |||
How do I eliminate numerous "Mail Merge..." under my tool bar? | Microsoft Word Help | |||
mail merge to MAPI as a PDF attachment | Microsoft Word Help | |||
Mail Merge - Date Format | Microsoft Word Help | |||
How do I mail merge when only merge document is shown in tools? | Microsoft Word Help |