Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Word / Web Authoring / August 2003

Tip: Looking for answers? Try searching our database.

mailmerge from Access to Word to get hyperlinked text

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
tgwarrior - 20 Aug 2003 20:30 GMT
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*


Rate this thread:






 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.