#1
|
|||
|
|||
Macro to convert urldefense URLs into regular ones?
My company just started using ProofPoint for email security. It converts all incoming URLs into something like this, with the real URL (bolded) surrounded by protection:
https://urldefense.com/v3/__https://www.theatlantic.com/health/archive/2020/03/coronavirus-anxiety/608317/__;!!BspMT6SJLSDJ!YOvVk1wvd5VfFUtGzaX_UL4p9xaTK9Sc yK3eF1tJmuqc4yT0MV2Rs-z0Ws1Bw-Pjw7jU$ I often receive essays for publication that are in the body of an email. Our publishing platform doesn't play nicely with the the urldefense URLs. I convert them by pasting the content into Word, clicking on individuals URLs, going to the page I'm directed to, copying the real URL, and returning to Word to paste it over the urldefense one. If there are a dozen or more in a document, this can take time. The format seems to be the same for each urldefense URL. Is it possible to write a macro in Word to 1) reveal the URLs and in a document and 2) convert them into the targets URLs? As a novice, I'm not sure where to start. Many thanks, pjs |
#2
|
||||
|
||||
For examples such as the one you posted, a clean-up could be done via a wildcard Find/Replace, where:
Find = https://urldefense*(http*)__;\!*$ Replace = \1 No VBA code required.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
Tags |
urls |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Macro to convert formatting? | CTHockeyBA | Word VBA | 1 | 09-25-2018 06:13 PM |
Macro to convert table to convert table into iCalendar file? | Weboh | Word VBA | 5 | 12-10-2016 03:07 PM |
Convert endnote/footnote to regular text | Cobb78 | Word | 5 | 07-11-2016 06:23 AM |
Macro to convert data | unwantedoz | Excel Programming | 1 | 10-17-2015 05:28 AM |
convert numbered list to regular text | Cobb78 | Word | 1 | 05-26-2012 05:09 PM |