+ Reply to Thread
Results 1 to 3 of 3

Replace Word bookmark with email address with an new email address

  1. #1
    Registered User
    Join Date
    06-13-2012
    Location
    USA
    MS-Off Ver
    Excel 2010
    Posts
    8

    Replace Word bookmark with email address with an new email address

    Hello all

    I am using the following code to replace the text in a Word bookmark. When the the hyperlinked bookmark updates, the text is replaced but the font color and size change and the bookmark disappears.

    Will someone be so kind to show me how to replace a email address hyperlinked in a bookmark with another hyperlinked email address?

    I will be eternally grateful

    Please Login or Register  to view this content.

  2. #2
    Forum Expert macropod's Avatar
    Join Date
    12-22-2011
    Location
    Canberra, Australia
    MS-Off Ver
    Word, Excel & Powerpoint 2003 & 2010
    Posts
    3,831

    Re: Replace Word bookmark with email address with an new email address

    You need to understand that clickable email addresses (which your description suggests that's what you're working with) use hyperlink fields. Accordingly, you need to update the bookmarked hyperlink, not the bookmarked content. In any event, your code doesn't update the bookmarked content; it deletes that content and inserts new content after the bookmark. You need to use code like, for example:
    Please Login or Register  to view this content.
    Cheers,
    Paul Edstein
    [Fmr MS MVP - Word]

  3. #3
    Registered User
    Join Date
    06-13-2012
    Location
    USA
    MS-Off Ver
    Excel 2010
    Posts
    8

    Re: Replace Word bookmark with email address with an new email address

    "Hip, hip, hoorah, Hip, hip, hoorah,Hip, hip, hoorah!!!

    3 cheers for you mate. Quick and on target

    Thank you very much

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. 1 email per email address, include cell value in email subject
    By melody10 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 03-31-2019, 10:27 PM
  2. [SOLVED] vba email send from excel - ignore second email address if "ENTER EMAIL ADDRESS"
    By nigelog in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-28-2016, 07:22 AM
  3. Email a screenshot of a specifc row in an email to a specfic email address
    By Cobra75007 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 08-19-2015, 10:36 AM
  4. Macro - Save Word as PDF with Unique Name and Email PDF to specified email address.
    By newbie1234 in forum Word Programming / VBA / Macros
    Replies: 6
    Last Post: 07-08-2014, 11:54 PM
  5. Replies: 1
    Last Post: 03-08-2012, 01:57 PM
  6. Replace Customer email address with blank
    By guru420 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-23-2011, 03:41 PM

Tags for this Thread

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1