Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 08-07-2021, 12:39 PM
CoventryKid CoventryKid is offline Format of merged fields confusing... Windows 10 Format of merged fields confusing... Office 2016
Novice
Format of merged fields confusing...
 
Join Date: Mar 2021
Location: Vancouver Island, BC
Posts: 5
CoventryKid is on a distinguished road
Default Format of merged fields confusing...

I finally decided to "convert" my old mail merge system (Word/Excel 97-2003) to my current system (Word/Excel 2016). I merge client data from an Excel spreadsheet with Word "form" documents to produce Packing Slips, Invoices, and mailing Labels.

I understand the basics of the new (to me) Mail Merge.

What I do not understand is the formatting of the various fields. The 97-2003 Mail Merge applied the formats in Excel to the Word form documents. If the formats were correct in Excel, they were also correct in the Word form document.

No so with the 2016 Excel and Word mail merge. It seems a step backward to have to apply the correct format in the Word form document, especially when the correct format is already in the Excel data file.



What is even more confusing is that in my Invoice form document, where I list the items being sold, ONE of the line entries displays the CORRECT format from the Excel spreadsheet. ALL of the remaining line entries, sub total, taxes, and grand total lines DO NOT. WHY IS THAT? I have not figured that out. Even "Format Painting" the correct format does nothing (I didn't expect that it would).

Needless to say, I am not all that impressed with this version of Mail Merge. With a bit of effort it will work. But I would sure like to ask the powers-that-be at Microsoft, why this latest version (2016) of Word/Excel creates more work for me (the end user) than the older version. NEWER IS NOT ALWAYS BETTER.

Thanks for letting me rant.

Doug
Reply With Quote
  #2  
Old 08-07-2021, 08:35 PM
gmayor's Avatar
gmayor gmayor is offline Format of merged fields confusing... Windows 10 Format of merged fields confusing... Office 2019
Expert
 
Join Date: Aug 2014
Posts: 4,101
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 of
Default

Nothing has changed, except the way the merge document is connected to the data source. Early Word versions used DDE which was notoriously flaky but it did provide the format from Excel.

That option is still available - From the File tab in Word, select Options and then go to the Advanced tab, General sub heading and check the box against the "Confirm file format conversion on open" item. Then when you attach the data source to the mail merge main document, you will be given the option of using the DDE method of connection which should read the data as you have it formatted in the table.

However I don't recommend it as it is unreliable and no longer the default (and may be abandoned altogether). It is better to use formatting switches to provide the required format - see Formatting fields with switches
__________________
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
  #3  
Old 08-08-2021, 01:28 PM
CoventryKid CoventryKid is offline Format of merged fields confusing... Windows 10 Format of merged fields confusing... Office 2016
Novice
Format of merged fields confusing...
 
Join Date: Mar 2021
Location: Vancouver Island, BC
Posts: 5
CoventryKid is on a distinguished road
Default

Thanks Graham! I'm in the process of doing as you suggest as better to do it now rather than later.


Cheers!
Doug
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Verically spreading text (merged fields) in a table catflap Word Tables 2 08-08-2019 07:19 AM
Format of merged fields confusing... Format tables with vertically merged cells jeffreybrown Word VBA 2 01-16-2019 03:23 PM
Format of merged fields confusing... Merged Checkbox Fields Always Checked pdxplorer Mail Merge 11 12-20-2017 12:37 PM
Format of merged fields confusing... Odd Result In Combined Merged Time Fields JennEx Mail Merge 9 04-29-2017 08:58 AM
Format of merged fields confusing... Adding sequential Number in a document that already has merged fields inserted Highlander01 Mail Merge 3 01-19-2016 12:33 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 05:58 AM.


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