Why the "day" is not inserted as we read values from Excel to Word?



please, see the attached image that shows my question

i need to write the "day and the date" from excel to word and this is why i used "mailing and insert fields"

the problem that the day appears correctly in the Excel but doesn't in Word!!!! the date is written without the day!!!!!!

How to solve this problem?

regards

Jamal

Attached Images

Clip_3.jpg (74.8 KB, 11 views)

Hi Jumal,

Try this link, and look at the example by clicking on the '+'.

http://office.microsoft.com/en-us/wo...005186143.aspx

You need to edit the field code to show the date in the format you require.

Hope this helps.

thank you for the answer nutrastat.

i tried your hint but unfortunately it didn't work!

- the date is read from an excel file but not directly from Word
- the format is applicable for the current date but not for the dates listed in the excel file!

please, see the attached the images that shows my problem.

what i need is to have the dates listed in excel to be written in Word exactly as they are.

how can i do that? could you please elaborate more?

regards

Jamal

Attached Images

	Clip_912.jpg (82.0 KB, 8 views)
	Clip_913.jpg (101.7 KB, 9 views)
	Clip_914.jpg (90.4 KB, 8 views)

Attached Files

	New Microsoft Excel Worksheet.xlsx (9.6 KB, 9 views)
	New Microsoft Word Document.docx (14.7 KB, 12 views)

Hi Jamal,

Right click on the field, edit field, go to field codes and insert...

MERGEFIELD \@ "dddd, MMMM d, yyyy"

THis will then give you a complete date, by removing the d, M, or Y it will shorten the string displayed.

Hope this helps.

Hi Jamal,

I have CHANGED your two documents.

Excel: I have put the dates into different formats (CTRL+1). The format of the field DOES NOT MATTER, because all excel dates are held as numbers. Changed the header to Date, because it does not matter whether there is a day there or not.

Word: Then I put in the field code into the Word docment. Right-click date, toggle field codes and the whole string will be seen. Do not forget to toggle it back!

The way that the date is formatted comes down to how many 'd', 'M' or 'y' that you have within the quotation marks. For instance, add another couple of 'M' (4 x M = MMMM) and you will find it will give you the whole month name, whereas, 3 x M's will give you an abbreviated months name.

You now have various date formats in the Excel file, which will all look the same when mail merged into the word document, irrespective of their original formatting.

Hope this now answers all of your questions.

Attached Files

	Jamal Doc.docx (14.9 KB, 9 views)
	Jamal Excel.xlsx (9.6 KB, 9 views)

thank you Nutrastat. it worked like a charm.

regards

Jamal

Attached Images

Clip_919.jpg (87.0 KB, 8 views)

Hi Jamal,

Pleased to have a satisfied customer!

Please remember to mark your question as 'Solved' - thanks.

i did. ver much appreciated.

regards

jamal

once again in trouble!!!!!!

i couldn't have the format that i need while inserting values from Excel to Word!!!!!!!

i thought that the code: \@ "dddd, mmmm d, yyyy" is able to read exactly what we have in Excel!!!!

How to have the same value format when inserting from Excel to Word????

regards

Jamal

Attached Images

	Clip_961.jpg (105.2 KB, 8 views)
	Clip_962.jpg (100.3 KB, 8 views)
	Clip_963.jpg (109.9 KB, 8 views)

Attached Files

	New Microsoft Excel Worksheet_date.xlsx (10.5 KB, 9 views)
	New Microsoft Word Document.docx (15.6 KB, 10 views)