Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #4  
Old 05-07-2014, 04:08 PM
macropod's Avatar
macropod macropod is offline Loss of formulae values when mail merging excel to word Windows 7 32bit Loss of formulae values when mail merging excel to word Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,467
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
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Loss of formulae values when mail merging excel to word Mailing: Reading values from Excel to Word Jamal NUMAN Excel 9 09-02-2011 02:08 AM
Merging word files from excel macro hklein Excel Programming 0 08-05-2011 02:27 AM
Mail merging and pulling varying data from Excel shannag1881 Mail Merge 0 10-05-2009 08:51 AM
Word - Calculate and paste values from Excel sheet Augf87 Word 1 07-06-2009 10:26 AM
HELP! Merging Excel to Word peevenjo Mail Merge 0 07-06-2007 03:24 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 07:29 PM.


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