Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
gorfinneed gorfinneed is offline
external usenet poster
 
Posts: 2
Default Merge field is not displaying properly

I am puzzled, i have a merge field (excel 2003) that is drawing in from a
formula that gives me the name of a day relative to a date (ie; 16 April 2008
= Wednesday)
however the merge ifeld result just gives me a date "1/4/1900". I have
tried to add a switch \@"dddd" or \@"DDDD", but neither have worked.

I even deleted the formula and typed in the Day manually in the excel file,
however the merge filed resul is the same "1/4/1900". Help! Please
  #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 Merge field is not displaying properly

That switch certainly works for me. What is the field actually displaying
in Excel. In my case, I had one column of dates and in another column I had
a formula that added 1 to the date in the adjacent column and the cells in
that column were formatted in Excel to show the date of the week. Without
the switch, the mail merge returned the date in place of the day of the
week, but with the switch, it returned the day of the week.

--
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

"gorfinneed" wrote in message
...
I am puzzled, i have a merge field (excel 2003) that is drawing in from a
formula that gives me the name of a day relative to a date (ie; 16 April
2008
= Wednesday)
however the merge ifeld result just gives me a date "1/4/1900". I have
tried to add a switch \@"dddd" or \@"DDDD", but neither have worked.

I even deleted the formula and typed in the Day manually in the excel
file,
however the merge filed resul is the same "1/4/1900". Help! Please



  #3   Report Post  
Posted to microsoft.public.word.mailmerge.fields
gorfinneed gorfinneed is offline
external usenet poster
 
Posts: 2
Default Merge field is not displaying properly

Thanks Doug, I unfortunately was not able to get it to work. The field is
displaying the day "ie: Wednesday". My answer was to actually delete the
column as in the adjacent coulmn was the date and I just formatted the date
to show day date, month, year...and placed a switch in the merge field that
worked.

"Doug Robbins - Word MVP" wrote:

That switch certainly works for me. What is the field actually displaying
in Excel. In my case, I had one column of dates and in another column I had
a formula that added 1 to the date in the adjacent column and the cells in
that column were formatted in Excel to show the date of the week. Without
the switch, the mail merge returned the date in place of the day of the
week, but with the switch, it returned the day of the week.

--
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

"gorfinneed" wrote in message
...
I am puzzled, i have a merge field (excel 2003) that is drawing in from a
formula that gives me the name of a day relative to a date (ie; 16 April
2008
= Wednesday)
however the merge ifeld result just gives me a date "1/4/1900". I have
tried to add a switch \@"dddd" or \@"DDDD", but neither have worked.

I even deleted the formula and typed in the Day manually in the excel
file,
however the merge filed resul is the same "1/4/1900". Help! Please




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
Displaying field names in merge (but not when blank) Burt Mailmerge 2 December 7th 07 11:02 AM
Excell Data not displaying properly Dave Mailmerge 2 May 16th 07 06:13 AM
Links not displaying properly Hines4234 Microsoft Word Help 1 November 17th 06 06:24 PM
Mail Merge Not Reading Field Codes Properly Sandi Mailmerge 4 February 21st 06 08:17 PM
Mail merge field isn't displaying all the text in a field. Can I . mojohubbard Mailmerge 3 March 28th 05 04:45 PM


All times are GMT +1. The time now is 02:17 PM.

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

About Us

"It's about Microsoft Word"