Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Earl Earl is offline
external usenet poster
 
Posts: 5
Default 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   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Doug Robbins - Word MVP Doug Robbins - Word MVP is offline
external usenet poster
 
Posts: 8,832
Default 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

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Linked text boxed in Word 2007 do not work correctly Data Guy Microsoft Word Help 1 October 15th 07 10:11 AM
Formatting of merged fields for date and times doesn't work with E RJR Mailmerge 3 February 19th 07 07:41 AM
mail merging date fields from excel pama Mailmerge 5 November 21st 06 05:35 PM
Blank date fields in Excel merging with Date/Time margaret Mailmerge 1 March 16th 06 05:36 PM
formatting of linked Excel text Nick Turner Microsoft Word Help 1 March 6th 06 09:16 AM


All times are GMT +1. The time now is 12:48 PM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"