Results 1 to 5 of 5
  1. #1
    4 Star Lounger
    Join Date
    Apr 2002
    Location
    Northern Territory, Australia
    Posts
    471
    Thanks
    16
    Thanked 0 Times in 0 Posts

    Merge to Word hyperlink format

    Hello

    In my database I have a field which contains a hyperlink. I have used this field in a query to populate a Mail Merge in Word. (2010) In the word document it appears as text and not a hyperlink ie 269972#http://meteor.aihw.gov.au/content/in...itemId/269972#.

    Any suggestions why this has happened?

    Kerry

  2. #2
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,623
    Thanks
    3
    Thanked 60 Times in 60 Posts
    It's been a long time since I tried to do that sort of thing, but I seem to recall that you need to embed the mail merge field within the field codes in Word that define text to be a hyperlink. Can you provide more details on the word merge field? A sample document would be helpful.
    Wendell

  3. #3
    Super Moderator
    Join Date
    May 2002
    Location
    Canberra, Australian Capital Territory, Australia
    Posts
    5,054
    Thanks
    2
    Thanked 417 Times in 346 Posts
    See 'Mailmerge Hyperlink ‘Click Here’ Insertion' in the Mailmerge Tips and Tricks 'Sticky' thread in the Word forum:
    http://windowssecrets.com/forums/sho...ips-amp-Tricks
    Cheers,

    Paul Edstein
    [MS MVP - Word]

  4. #4
    4 Star Lounger
    Join Date
    Apr 2002
    Location
    Northern Territory, Australia
    Posts
    471
    Thanks
    16
    Thanked 0 Times in 0 Posts

    HTML Format in Merged Document from Database

    The document "WordMailmerge Tips and Trips" is excellent, however, I now have another problem which doesnt seem to be addressed in it.

    I have a memo field in my database which I have set to be RTF format. I am using this in my mailmerge, however it is appearing in the document with the HTML showing. How do I get rid of this?

    <div><font face=Arial size=2>Guide for use:</font></div>

    Kind Regards
    Kerry

  5. #5
    Super Moderator
    Join Date
    May 2002
    Location
    Canberra, Australian Capital Territory, Australia
    Posts
    5,054
    Thanks
    2
    Thanked 417 Times in 346 Posts
    A mailmerge can only output what's actually in your data. Since the data contain the "<div><font face=Arial size=2>" and "</font></div>" strings, the mailmerge can't delete them. You may need to modify the database so it also holds a plain text version of your rich text memo fields.
    Cheers,

    Paul Edstein
    [MS MVP - Word]

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •