|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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®=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®=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®=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®=PPP 123&driver=Mick Smith <https://ourcompanyname.typeform.com/...3R?&name=MR%20 Fred&date=121216&our_ref=11134®=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®=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®=PPP%20123&drive r=Mick%20Smith> |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Excel link in Powerpoint issue | gebobs | Excel | 1 | 10-13-2015 11:22 PM |
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 |