#1
|
|||
|
|||
Why the "day" is not inserted as we read values from Excel to Word?
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
__________________
Jamal NUMAN, Jamal432@gmail.com, P.O.BoX: 731, Ramallah, West Bank. |
#2
|
|||
|
|||
Date Field Switch Required
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. |
#3
|
|||
|
|||
Quote:
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
__________________
Jamal NUMAN, Jamal432@gmail.com, P.O.BoX: 731, Ramallah, West Bank. |
#4
|
|||
|
|||
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. |
#5
|
|||
|
|||
Just Needed To Edit Field Code!
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. |
#6
|
|||
|
|||
Quote:
regards Jamal
__________________
Jamal NUMAN, Jamal432@gmail.com, P.O.BoX: 731, Ramallah, West Bank. |
#7
|
|||
|
|||
Hi Jamal,
Pleased to have a satisfied customer! Please remember to mark your question as 'Solved' - thanks. |
#8
|
|||
|
|||
Quote:
regards jamal
__________________
Jamal NUMAN, Jamal432@gmail.com, P.O.BoX: 731, Ramallah, West Bank. |
#9
|
|||
|
|||
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
__________________
Jamal NUMAN, Jamal432@gmail.com, P.O.BoX: 731, Ramallah, West Bank. |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
marking email as "read" until email is read on local device. | mwomack | Outlook | 2 | 07-16-2011 08:21 PM |
Why the left edge of an inserted table is out "text boundary" by default? | Jamal NUMAN | Word Tables | 2 | 06-30-2011 04:47 PM |
Outlook 2007 - Receiving Multiple "read receipts" from a single email | garp2100 | Outlook | 1 | 12-03-2010 07:10 AM |
"Microsoft Excel Application" missing in the "Component Services" on win08 | sword.fish | Excel | 0 | 02-26-2010 02:09 PM |
merge field formatting problem with "text to be inserted before" | wissam | Mail Merge | 0 | 12-13-2009 12:50 AM |