Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 03-31-2020, 04:25 AM
pjs15 pjs15 is offline Macro to convert urldefense URLs into regular ones? Windows 10 Macro to convert urldefense URLs into regular ones? Office 2019
Novice
Macro to convert urldefense URLs into regular ones?
 
Join Date: Feb 2020
Posts: 7
pjs15 is on a distinguished road
Default 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
Reply With Quote
  #2  
Old 03-31-2020, 05:33 PM
macropod's Avatar
macropod macropod is offline Macro to convert urldefense URLs into regular ones? Windows 7 64bit Macro to convert urldefense URLs into regular ones? Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

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]
Reply With Quote
Reply

Tags
urls

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Macro to convert urldefense URLs into regular ones? Macro to convert formatting? CTHockeyBA Word VBA 1 09-25-2018 06:13 PM
Macro to convert urldefense URLs into regular ones? Macro to convert table to convert table into iCalendar file? Weboh Word VBA 5 12-10-2016 03:07 PM
Macro to convert urldefense URLs into regular ones? Convert endnote/footnote to regular text Cobb78 Word 5 07-11-2016 06:23 AM
Macro to convert urldefense URLs into regular ones? Macro to convert data unwantedoz Excel Programming 1 10-17-2015 05:28 AM
Macro to convert urldefense URLs into regular ones? convert numbered list to regular text Cobb78 Word 1 05-26-2012 05:09 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 07:05 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft