Thread: Loss of formulae values when mail merging excel to word
View Single Post
 
Old 05-07-2014, 04:08 PM
macropod's Avatar
macropod macropod is offline Windows 7 32bit Office 2010 32bit
Administrator
  
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,366
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
You can eliminate the spaces with a field coded as:
{QUOTE{SET ID {MERGEFIELD SSN}}{SET EXP1{=-{=-{ID}-ID}/2}}{SET EXP2{=-({ID}*(-1)-{ID})/2}}{SET EXP3{=({ID}*(-1)-ID)/2}}{=EXP1*1000000+EXP2*10000+EXP3 \#000000000}}
However, whether you'll be able to use that depends on how the other software to which you refer updates the document.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote