I've been playing with a calculation in a query so that
when I mailmerge into Word I get hyperlinked text. (so
that i can then save the word document as HTML and have
workable hyperlinks)
Basically I want to have the authors name hyperlinked with
their email address. Not all authors have email
addresses, so:
AuthorAdd: IIf(IsNull([Author_email]),[Author],"<a
href=mailto:"+[Author_email]+">"+[Author]+"</a>")
When I do this, though, it obviously mailmerges into word
and what ends up showing up is, e.g.:
<a href=mailto:patsmith@zzz.com>Pat Smith</a>
RATHER than "Pat Smith" who's name is hyperlinked to her
email address.
Likewise, I want to create an active URL for the
publications.
Here is the query calculation:
PublicationAdd: IIf(IsNull([Publication_URL]),
[Publication],"<a href="+[Publication_URL]+">"+
[Publication]+"</a>")
Again, rather than putting the name of the newspaper which
can be clicked to their URL, it results in, e.g.
<a href=http://www.cnn.com>CNN</a>
Any suggestions? Thanks
michael
tgwarrior@forge-forward.org
Bob Buckland ?:-\) - 21 Aug 2003 17:08 GMT
Hi Michael,
Word can recognize items 'typed' as URLs in a document
if the Autocorrect settings for that are turned on.
You didn't mention the version of Word you're using
but, for example, if you were to type
"mailto:patsmith@zzz.com" (without the quotes) rather than
<a href=mailto:patsmith@zzz.com>Pat Smith</a>
for example Word will convert the first one to a hyperlink
likewise typing
'http://www.cnn.com' rather than
<a href=http://www.cnn.com>CNN</a>
will work in a Word document whether you save
it as .HTM or .DOC format.
============
I've been playing with a calculation in a query so that
when I mailmerge into Word I get hyperlinked text. (so
that i can then save the word document as HTML and have
workable hyperlinks)
Basically I want to have the authors name hyperlinked with
their email address. Not all authors have email
addresses, so:
AuthorAdd: IIf(IsNull([Author_email]),[Author],"<a
href=mailto:"+[Author_email]+">"+[Author]+"</a>")
When I do this, though, it obviously mailmerges into word
and what ends up showing up is, e.g.:
<a href=mailto:patsmith@zzz.com>Pat Smith</a>
RATHER than "Pat Smith" who's name is hyperlinked to her
email address.
Likewise, I want to create an active URL for the
publications.
Here is the query calculation:
PublicationAdd: IIf(IsNull([Publication_URL]),
[Publication],"<a href="+[Publication_URL]+">"+
[Publication]+"</a>")
Again, rather than putting the name of the newspaper which
can be clicked to their URL, it results in, e.g.
<a href=http://www.cnn.com>CNN</a>
Any suggestions? Thanks
michael>>

Signature
I hope this helps you,
Bob Buckland ?:-)
MS Office System Products MVP
*Courtesy is not expensive and can pay big dividends*