Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Excel linked fields w/date and/or text -will not work for all colu
I have two columns with dates in excel as mm/dd/yy, formatted the same, as
text. Both are linked to the same word document and have the date format switches to month day, 20XX. Conditional formatting is set-up for the sheet to alternate shading of rows. The secondary column displays the date but not text 'n/a' or anyother text. The primary column always has a date, but a test since this problem shows it will display text also. This problem started with the use of Office 2007. Thanks in advance |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Excel linked fields w/date and/or text -will not work for all colu
Click on the Office button and then on the Word Options button in the bottom
border and then on the Advanced button and scroll down to the General section of the dialog and check the box against "Confirm file format conversion at open." Then when you re-attach the data souce to the mail merge main document, select the DDE option. -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP "Earl" wrote in message ... I have two columns with dates in excel as mm/dd/yy, formatted the same, as text. Both are linked to the same word document and have the date format switches to month day, 20XX. Conditional formatting is set-up for the sheet to alternate shading of rows. The secondary column displays the date but not text 'n/a' or anyother text. The primary column always has a date, but a test since this problem shows it will display text also. This problem started with the use of Office 2007. Thanks in advance |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Linked text boxed in Word 2007 do not work correctly | Microsoft Word Help | |||
Formatting of merged fields for date and times doesn't work with E | Mailmerge | |||
mail merging date fields from excel | Mailmerge | |||
Blank date fields in Excel merging with Date/Time | Mailmerge | |||
formatting of linked Excel text | Microsoft Word Help |