Importing Excel fields into Word - Microsoft Community


for years i've been producing word documents fields imported excel names , important details. word 2007 import amount field containing 35.00 , prints 35.00. word 2017 prints 35. how can fix print properly?

 ***post moved moderator appropriate forum category.***

dde technology old , quite inflexible compared ole db provider used default in word 2002 & later. control output formatting, see mailmerge tips , tricks threads at:
http://www.msofficeforums.com/mail-merge/21803-mailmerge-tips-tricks.html
&:
http://windowssecrets.com/forums/showthread.php/163017-word-mailmerge-tips-amp-tricks
 
amongst other things, topics addressed include:
conditionally merge spouse data
conditionally shade table cells
convert mailmerge date fields plain text
dealing null values in mailmerge arithmetic
force '0' substitution empty/missing records
mailmerge checkbox insertion
mailmerge date formatting
mailmerge empty space suppression
mailmerge empty line suppression
mailmerge hyperlink ‘click here’ insertion
mailmerge percentage formatting
mailmerge phone number formatting
mailmerge number & currency formatting
mailmerge string formatting
mailmerge string testing & test whether mergefield contains given string
mailmerge time formatting
mailmerge social security number formatting
mailmerge zip code formatting
managing mailmerge graphics
merge multiple fields, using commas , ‘and’
suppress output on unused labels in label merge
test whether text mergefield contains numeric data


Office / Word / Windows 10 / Office 2016



Comments

Popular posts from this blog

Can't Sign-in to OneDrive - Microsoft Community

Shared mailbox permissions - Microsoft Community

Outlook 2016 for Mac - Multiple Issues, Error 17884 - Microsoft Community