Mail merge from Access, with hyperlink field

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

troubadour - 09 Jun 2005 14:36 GMT

I try to mail merge a Word document, from an Access database query,
containing an hyperlink field (file://)
I obtain in Word the adress of the field, what i wished would have been its
content.
Is it better to try solution 1 ou 2 ?
1 : trying to do so that Access exports the content of the hyperlink field,
then Word just receives it
2 : trying to do so that Word transforms the adress into text
Thank you
GC

Reply to this Message

Doug Robbins - 09 Jun 2005 20:29 GMT

See the following page on fellow MVP Cindy Meister's website:

http://homepage.swissonline.ch/cindymeister/mergfaq2.htm#Hyperlink

Signature

Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

>I try to mail merge a Word document, from an Access database query,
> containing an hyperlink field (file://)
[quoted text clipped - 8 lines]
> Thank you
> GC

Reply to this Message

troubadour - 10 Jun 2005 09:42 GMT

Thank you Doug, i'll ry to do the way it is suggested in the web page you
mention.
PS : is it usual or annoying (for readers) to say thank you on the forum ?

Troubadour

> See the following page on fellow MVP Cindy Meister's website:
>
[quoted text clipped - 12 lines]
> > Thank you
> > GC

Reply to this Message

Doug Robbins - 10 Jun 2005 18:44 GMT

Unfortunately, since the proliferation of spam and the resulting posting by
people with an @discussion.microsoft.com "email address", these news groups
have become far less personal, so it is nice to receive a note of thanks.

Signature

Thanks and regards,
Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

> Thank you Doug, i'll ry to do the way it is suggested in the web page you
> mention.
[quoted text clipped - 18 lines]
>> > Thank you
>> > GC

Reply to this Message

Cindy M -WordMVP- - 11 Jun 2005 16:44 GMT

Hi =?Utf-8?B?dHJvdWJhZG91cg==?=,

> PS : is it usual or annoying (for readers) to say thank you on the forum ?

And we especially appreciate it if it's been a puzzling problem, since we
then know what it was that actually worked :-)

Whether it's unusual or annoying depends to a great extent on the individual
forum. Some "techy" groups find it annoying; a waste of time and band-width.
In other groups, with a more personal tone, it's tolerated or appreciated
(depending on the individuals). This set of groups (word) definitely fall
into the "personal" category :-)

Cindy Meister

Reply to this Message

Rate this thread: