#1
|
|||
|
|||
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 |
#2
|
||||
|
||||
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 |
#3
|
|||
|
|||
Thanks Graham! I'm in the process of doing as you suggest as better to do it now rather than later.
Cheers! Doug |
|
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 tables with vertically merged cells | jeffreybrown | Word VBA | 2 | 01-16-2019 03:23 PM |
Merged Checkbox Fields Always Checked | pdxplorer | Mail Merge | 11 | 12-20-2017 12:37 PM |
Odd Result In Combined Merged Time Fields | JennEx | Mail Merge | 9 | 04-29-2017 08:58 AM |
Adding sequential Number in a document that already has merged fields inserted | Highlander01 | Mail Merge | 3 | 01-19-2016 12:33 PM |