Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #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

 
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Mail merge - Word 2003/Access 2000 Russell Farr Mailmerge 7 March 24th 06 12:03 AM
How do I eliminate numerous "Mail Merge..." under my tool bar? JulieMae Microsoft Word Help 2 January 9th 05 10:45 PM
mail merge to MAPI as a PDF attachment MikeG Microsoft Word Help 1 December 13th 04 02:12 AM
Mail Merge - Date Format Kilinski Microsoft Word Help 0 December 7th 04 01:13 PM
How do I mail merge when only merge document is shown in tools? DaveAS Microsoft Word Help 2 December 1st 04 03:45 PM


All times are GMT +1. The time now is 06:01 PM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"