Hi everyone, I'm sorry if my english is not good, I'm from Italy and I've got a problem with merge between excel and word..
I've got an excel sheet automatically generated by the management program I use at work..
It's composed by 2 columns:

orcodart (the name of the every item of the order)

datalis (the date when I entered the price) if there is still no price in place of the date there is this code ( - -)

when I merge it in Word many times I've got this issue:
in place of "- -" when there is no date Word generate "12:00:00 AM" but i need to have "- -"
sometimes it works and generate "- -" but in this case it doesn't..

I attach the files

can you help me?
thanks bye

Attached Files

	prova.XLS (13.5 KB, 12 views)
	PROVA.doc (20.0 KB, 13 views)

Change the field construction to

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

__________________
Graham Mayor - MS MVP (Word) (2002-2019)
Visit my web site for more programming tips and ready made processes www.gmayor.com

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.

just another question if is possible
If I select "Confirm conversion at Open" from the Word Options and choosing again the source file excel it give me the possibility to select DDE.. In this way is possible to keep the same format of the Excel cells.. and it asks no format strings.. But everytime I open again the word file i have to select everytime the file Excel..
Is there a way to save the Word file including the Excel file inside?
thanks a lot
bye

Your underlying problem is that your 'datalis' field contains two data types. Approaches you might take to resolve it are discussed under Mailmerge Data Format Problems in the Mailmerge Tips & Tricks 'Sticky' thread at the top of this forum: https://www.msofficeforums.com/mail-...ps-tricks.html

DDE is old technology that was superseded by OLE DB over 15 years ago. When using DDE, you will always need the "Confirm conversion at Open" option.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

My only question about DDE it was: is possible to save the excel file DDE as database inside the word file? Reading on the web I've not found any solutions about it..

For the formatting of my OLEDB file Excel Gmayor has already solved my issue..

No. It is not possible to use content in a mailmerge main document as the datasource.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]