Graham,

Thanks again for the reply.

Please double check if hyperlinks were actually created by using the
statement in your message below or if the resulting text just looked like a
hyperlink (blue and underlined font). I've now tested on another machine
running Word 2003 and two separate machines running Word 2002 and Word 2000.
In each case, the text of the hyperlink appears but the hyperlink is not
active.

A few other observations:
- If the AutoText entry is a hyperlink of one or more words, it will appear
formatted like a hyperlink, however, if it is a string of text with only part
of the string being a hyperlink (like "Click here to send an email" where
"Click here" is a hyperlink and the rest of the string is not), none of this
string will be formatted like a hyperlink.
- If only AUTOTEXT statements are used within the IF statement as in your
example below AND if the entire AutoText entry was created from just a
hyperlink, then the resulting text will appear formatted like a hyperlink,
however, if any text is placed before or after the AUTOTEXT statement (like
"Text before {AUTOTEXT AutoTextEntry1}" or "{AUTOTEXT AutoTextEntry1} text
after") then the resulting text will not be formatted like a hyperlink.
- The appearance of hyperlink formatting (blue and underlined font) for
AutoText inserted into a document appears to be impacted by the document
formatting at the point of insertion. In some cases, the resulting text
doesn't appear to be a hyperlink (not blue and underlined font) although it
is (mousing over changes cursor and displays ScreenTip, clicking goes to
link).
- If, after placing an AUTOTEXT statment within an IF statement, you right
click and select "Update Fields", the result of the statement is displayed.
If you then place the cursor before the first character of the result, right
click and select "Toggle Field Codes", the IF statement will appear with the
AutoText entry as it should appear (as opposed to the AUTOTEXT statment).
This entry is actually an active hyperlink (as it should be) but doesn't
survive the translation within the IF statement when field codes are toggled
back or the field updated to display the result.

Regards, Mark V


"Graham Mayor" wrote:

I tested this before posting and the hyperlinks were inserted in the merged
document here. The Autotexts were reproduced exactly.

{IF {Mergefield fieldname} = condition "{Autotext textname1}" "{Autotext
textname2"}

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org




Mark V wrote:
Graham,

Thanks for the quick reply.

Saving the hyperlinks as formatted AutoText entries and inserting
them into the document using the AUTOTEXT field works fine but only
the text (not the hyperlink) appears when the AUTOTEXT field is
embedded within the IF...THEN...ELSE statement. This is exactly what
I'm seeing with formatted hyperlinks that I simply cut and paste into
the IF...THEN...ELSE statement.

On a related note, the formatted AutoText entries should be created
(by highlighting the formatted hyperlink and selecting Insert,
AutoText, New from the menu) with paragraph formatting included (by
highlighting the paragraph mark before creating the entry) to ensure
that the text looks like a hyperlink (different color and
underlined). If the paragraph formatting isn't included, the text
won't look like a hyperlink but will function as a hyperlink should
the mouse be placed over it.

Any other suggestions for including hyperlinks in IF...THEN...ELSE
statements?

Thanks, Mark V

"Graham Mayor" wrote:

Saving the hyperlinks as formatted autotext entries and inserting
autotext fields via your conditional field should work.

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org




Mark V wrote:
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