Microsoft KB Archive/283172

= WD2000: Merged Hyperlinks from Access Contain Extra Information =

Article ID: 283172

Article Last Modified on 10/28/2002

-

APPLIES TO


 * Microsoft Word 2000 Standard Edition

-



This article was previously published under Q283172



SYMPTOMS
When you perform a mail merge in Microsoft Word, using a Microsoft Access database with hyperlinked data in it, the resulting merged data has two parts: the linked reference and the text reference.

For example, the address &quot;somebody@microsoft.com&quot; appears in the merged document as follows:

somebody@microsoft.com#http://somebody@microsoft.com#



CAUSE
This behavior occurs because the subaddress information of the hyperlinked field is converted and displayed along with the address itself.



RESOLUTION
The following method filters out only the address portion of the hyperlinked field:  Start Access and open the database that contains the mail merge information. Click Queries, and then click Create a query in Design view. Select the table with the mail merge information, click Add, and then click Close. Add the following syntax to the Field line in the query design grid:

newEmailField: Left([oldEmailField],InStr([oldEmailField],&quot;#&quot;)-1)

NOTE: Substitute the name of your hyperlink field for &quot;oldEmailField.&quot; Save the query and quit Access. Base your mail merge document on the preceding query, and use &quot;newEmailField&quot; as the merge field.</li></ol>

<div class="moreinformation_section">

MORE INFORMATION
In Access, a hyperlink address can have up to four parts that are separated by the number sign (#):

displaytext#address#subaddress#screentip

When you type only the e-mail address, for example, somebody@microsoft.com, Access stores it as both the address and subaddress portion of the hyperlink field in the following format:

somebody@microsoft.com#http://somebody@microsoft.com#

When you subsequently use this field in a mail merge operation, the entire string is converted to text.

Keywords: kbprb KB283172

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.