Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 06-20-2018, 01:59 AM
gmayor's Avatar
gmayor gmayor is offline Percentage letter merge Windows 10 Percentage letter merge Office 2016
Expert
 
Join Date: Aug 2014
Posts: 4,144
gmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud of
Default

Mail merge reads the underlying data from Excel, not the displayed format. You need to use a calculated field construction { ={ MERGEFIELD Fieldname } * 100 \# "0%"}


(see http://www.gmayor.com/formatting_word_fields.htm )
__________________
Graham Mayor - MS MVP (Word) (2002-2019)
Visit my web site for more programming tips and ready made processes www.gmayor.com
Reply With Quote
  #2  
Old 06-20-2018, 03:38 AM
Timhen Timhen is offline Percentage letter merge Windows 10 Percentage letter merge Office 2013
Novice
Percentage letter merge
 
Join Date: Jun 2018
Posts: 2
Timhen is on a distinguished road
Default

Thanks, i formatted it in Excel
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Percentage letter merge Letter from Mail Merge Redundancy Record zidan3311 Mail Merge 3 10-04-2017 12:54 PM
Percentage letter merge How do I mail merge multiple rows into one letter? SusiLouhh Mail Merge 1 03-17-2017 09:03 PM
Mail Merge Letter ChrisMcGann Mail Merge 2 10-23-2013 08:58 AM
Percentage letter merge formating a percentage in a Mail Merge dkalsow Mail Merge 3 04-03-2012 03:38 PM
Percentage letter merge Merge excel info into word letter. curatorfm Mail Merge 1 03-20-2011 04:26 AM

Other Forums: Access Forums

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