Graham,
Are you suggesting running AutoFormat (using the options listed below) on
the document after typing in all of the desired AUTOTEXT statements within IF
statements and before completing the merge? If so, this doesn't seem to
change anything.
My understanding of the AutoFormat "Replace Internet and network paths with
hyperlinks" option is that it is intended to identify and create a hyperlink
for any text that looks like an internet or network path. It will not
replace this text with "friendly" text (for instance, taking
"www.microsoft.com", creating a hyperlink to "http://www.microsoft.com" and
setting the Text to Display to "Microsoft") and it has no effect on the
following:
- A URL included within an IF statement (for instance, "{ IF condition
"http://www.microsoft.com" })
- A HYPERLINK statement included within an IF statement (for instance, "{ IF
condition "{ HYPERLINK "http://www.microsoft.com" })
- A hyperlink pasted into an IF statement (which results in adding a
HYPERLINK statement to the IF statement but also sets the Text to Display to
the "friendly" text specified when the hyperlink was created).
It appears that Word (going back to at least Word 2000) has problems
processing hyperlinks within IF statements, regardless of whether they are
manually typed into the IF statement, pasted in, included via a HYPERLINK
statement, included via an INCLUDETEXT statement or included via a AUTOTEXT
statement.
If I'm misinterpreting something or doing something wrong, I'm all ears...
Thanks, Mark V
"Graham Mayor" wrote:
In that case simply run autoformat on the merged document with the internet
and network paths to hyperlinks option set.
With Options
.AutoFormatApplyHeadings = False
.AutoFormatApplyLists = False
.AutoFormatApplyBulletedLists = False
.AutoFormatApplyOtherParas = False
.AutoFormatReplaceQuotes = False
.AutoFormatReplaceSymbols = False
.AutoFormatReplaceOrdinals = False
.AutoFormatReplaceFractions = False
.AutoFormatReplacePlainTextEmphasis = False
.AutoFormatReplaceHyperlinks = True
.AutoFormatPreserveStyles = False
.AutoFormatPlainTextWordMail = False
End With
Selection.Document.Kind = wdDocumentNotSpecified
Selection.Range.AutoFormat
--
Graham Mayor - Word MVP
My web site www.gmayor.com
Word MVP web site http://word.mvps.org
Mark V wrote:
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