problem with merge excel file into word

blanka · #1 11-19-2018, 08:58 AM

Quote:

Originally Posted by gmayor

Change the field construction to

{ IF { MERGEFIELD "datalis" } = "12:*" "- -" "{ MERGEFIELD "datalis" }" }

Thank you very much Gmayor

It seems to be the right solution!!!
I can't understand what is that text (12:00:00AM) gererated automatically.. (sometimes, not ever..)

but this fix the problem and it's the most important thing

Byeeee

Charles Kenyon · #2 11-19-2018, 12:44 PM

Quote:

Originally Posted by blanka

Thank you very much Gmayor

It seems to be the right solution!!!
I can't understand what is that text (12:00:00AM) gererated automatically.. (sometimes, not ever..)
but this fix the problem and it's the most important thing

Byeeee

This is because the actual data in Excel is the number 0 which when formatted as time give you midnight. Word, in doing a merge, ignores the formatting that is used in Excel.

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Excel to word Mail Merge problem	mark_kofi	Mail Merge	4	07-17-2018 03:49 PM
Merge one Excel file into multiple Word Documents	Rushpac	Mail Merge	2	01-27-2017 02:49 PM
Problem with saving Word file that is connected to Excel files that uses Powerpivot tables, charts	Paul-NYS	Office	2	08-24-2016 06:00 AM
A serious problem in integrating text file with an Excel file?	mradmin	Excel	12	10-25-2013 07:43 AM
Problem to view an Excel spreadsheet in Word file.	d-force	Word	2	08-28-2012 10:13 PM