Microsoft Office Forums

Go Back   Microsoft Office Forums > Microsoft Word > Mail Merge

Reply
 
LinkBack Thread Tools Display Modes
  #1  
Old 05-21-2018, 01:45 PM
Primož Primož is offline Mac OS X Office 2011 for Mac
Novice
 
Join Date: May 2018
Posts: 3
Primož is on a distinguished road
Default special characters from calculated excel spreadsheeet not shown

our alphabet uses special chracters such as č,š,ž.
i have a column with formula: =[@[POST NR]]&" "&[@POST NAME]
if post name contains any of the above characters they are shown as "_" in my word document using mail merge.
if the data in that column is hard writen it is fine. but it doesnt work when it is combined or calculated.


also tried =CONCATENATE([@[POST NR]];" ";[@POST NAME]) formula with the same result.
tried one cell to format as "general" and as "text" in excel spreadsheet with the same result
Reply With Quote
  #2  
Old 05-21-2018, 02:46 PM
macropod's Avatar
macropod macropod is offline Windows 7 64bit Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 19,468
macropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to behold
Default

It is strange that the Mac mailmerge converter won't see the characters if they're the result of a formula. That said, since the characters seem to be recognised when they're not the result of a formula, a workaround might be to copy the data and paste it on another sheet using Paste Special>Values to delete the formulae, then use that sheet for the merge.
__________________
Cheers,
Paul Edstein
[MS MVP - Word]
Reply With Quote
  #3  
Old 05-21-2018, 11:59 PM
Primož Primož is offline Mac OS X Office 2011 for Mac
Novice
 
Join Date: May 2018
Posts: 3
Primož is on a distinguished road
Default

im adding clients in that sheet all the time.
needing to special paste data every time before i create a new documents looses its purpose
Reply With Quote
  #4  
Old 05-22-2018, 12:03 AM
macropod's Avatar
macropod macropod is offline Windows 7 64bit Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 19,468
macropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to behold
Default

I appreciate that, but it's also apparent the Mac mailmerge converter doesn't handle the characters correctly if they're the result of a formula. The alternative to using a separate worksheet without formulae is to use mergefields that point to whatever [@POST NR] and [@POST NAME] point to.
__________________
Cheers,
Paul Edstein
[MS MVP - Word]
Reply With Quote
  #5  
Old 05-22-2018, 01:36 AM
Primož Primož is offline Mac OS X Office 2011 for Mac
Novice
 
Join Date: May 2018
Posts: 3
Primož is on a distinguished road
Default

the whole proces: im using 3 columns. POST NR, POST NAME, [POST NR]]&" "&[@POST NAME]. first 2 are for the clients living address. the last one is for a property at which they might not live. if they do the formula gives me the address already. if they dont, i have to change that address.
looks like the best option will be to just loose the formula and write the address in every time.
thanks anyway
Reply With Quote
  #6  
Old 05-22-2018, 04:24 AM
macropod's Avatar
macropod macropod is offline Windows 7 64bit Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 19,468
macropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to behold
Default

It's not apparent from your last post where the "property at which they might not live" comes from and how that relates to [POST NR]]&" "&[@POST NAME]. Perhaps you could attach a trimmed-down copy of your workbook with some representative data plus your mailmerge main document to a post (delete/obfuscate anything sensitive). That way I might be able to suggest a way to achieve the desired result via field coding in Word rather than via formulae in Excel.
__________________
Cheers,
Paul Edstein
[MS MVP - Word]
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Special characters in Word Peter Maggs Word 8 01-13-2017 02:41 PM
Interpreting special characters as bullets and indentations burry01 Word 1 01-18-2016 12:24 AM
Macros and special characters. oldzack Word 3 10-31-2011 04:16 AM
Special Characters missing timorrill Word 1 06-09-2009 11:34 PM
special/escape/insertion characters in word manojbmsce Word 0 09-25-2008 06:40 AM


All times are GMT -7. The time now is 12:14 PM.


Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.
MSOfficeForums.com is not affiliated with Microsoft