Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 12-08-2016, 08:33 AM
Alex Knight Alex Knight is offline Web string/link in Excel, Mail merged into Word and then pasted into Messages on Mac issue Mac OS X Web string/link in Excel, Mail merged into Word and then pasted into Messages on Mac issue Office 2016
Novice
Web string/link in Excel, Mail merged into Word and then pasted into Messages on Mac issue
 
Join Date: Dec 2016
Posts: 2
Alex Knight is on a distinguished road
Default Web string/link in Excel, Mail merged into Word and then pasted into Messages on Mac issue

OK. Sorry for the long title and hope someone can help. I will explain best I can.
Basically I need all the gaps in my string to be replaced with %20.
I need to achieve this either in the original excel document where the string is created (best option)
Or when the string is mail-merged in Word. But there is a secondary issue when the text, including the string is cut and pasted into Messages on my Mac

Below I will try and explain exactly what Im doing & trying to do



I have a database in Excel. A formula has been made so all the relevant information in the database is combined into a string that I want to send as a Text Message once merged to some additional text in Word

eg: The String created in Excel from fields is:
https://ourcompanyname.typeform.com/to/IKwV2S?&name=MR Fred&date=121216&our_ref=11134&reg=PPP 123&driver=Mick Smith

When I mail merg the string into a Word document the underlining disappears (but I can create a hyper link)


eg:

Dear Sir, please click the link below on your phone

https://ourcompanyname.typeform.com/to/IAwQ3R?&name=MR Fred&date=121216&our_ref=11134&reg=PPP 123&driver=Mick Smith

BECOMES

Dear Sir please click the link below on your phone

https://ourcompanyname.typeform.com/to/IAwQ3R?&name=MR Fred&date=121216&our_ref=11134&reg=PPP 123&driver=Mick Smith

But when this is pasted into Messages on my Mac it comes out like this:

Dear Sir please click the link below on your phone

https://ourcompanyname.typeform.com/to/IAwQ3R?&name=MR Fred&date=121216&our_ref=11134&reg=PPP 123&driver=Mick Smith
<https://ourcompanyname.typeform.com/...3R?&name=MR%20 Fred&date=121216&our_ref=11134&reg=PPP%20123&drive r=Mick%20Smith>

So I have to delete: https://ourcompanyname.typeform.com/to/IAwQ3R?&name=MR Fred&date=121216&our_ref=11134&reg=PPP 123&driver=Mick Smith

So Im left with

Dear Sir please click the link below on your phone

<https://ourcompanyname.typeform.com/...3R?&name=MR%20 Fred&date=121216&our_ref=11134&reg=PPP%20123&drive r=Mick%20Smith>
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Web string/link in Excel, Mail merged into Word and then pasted into Messages on Mac issue Excel link in Powerpoint issue gebobs Excel 1 10-13-2015 11:22 PM
Web string/link in Excel, Mail merged into Word and then pasted into Messages on Mac issue How to extract a word from an excel string with various lengths keywestsue Excel 3 09-18-2015 07:32 AM
Excel Multiple Rows Merged into Word (Vertical Format) ats1025 Mail Merge 3 11-19-2013 02:21 PM
Formatting Merged Time Values Between Excel & Word JennEx Mail Merge 1 07-12-2012 02:54 PM
Excel 07-Access 03 Data Link Issue ddw23 Excel 0 08-20-2010 09:05 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 09:55 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