Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
johnnygx johnnygx is offline
external usenet poster
 
Posts: 1
Default Using Excel 2007 to Merge Data to Word 2007 - How to Update Fields

I just upgraged to 2007 in the midst of a big mail merge project using Excel.
Now that I am adding new fields to Excel, the names of the fields are not
appearing in the drop down box when i need to insert them. The only thing
showing is the field number which does not coincide with anything
recognizable in excel. How do get word to identify with the name of the
field as it did with the previous fields?
Thx.
  #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 Using Excel 2007 to Merge Data to Word 2007 - How to Update Fields

Change the type of the mail merge main document to a Normal Word Document
(which will detach the data source from it, then change it back to the type
that it was originally and then re-attach the data source.

--
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, originally posted via msnews.microsoft.com

"johnnygx" wrote in message
...
I just upgraged to 2007 in the midst of a big mail merge project using
Excel.
Now that I am adding new fields to Excel, the names of the fields are not
appearing in the drop down box when i need to insert them. The only thing
showing is the field number which does not coincide with anything
recognizable in excel. How do get word to identify with the name of the
field as it did with the previous fields?
Thx.


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
how do I create fields in word 2007 to automatic update in excel? teric Microsoft Word Help 2 January 12th 10 05:11 AM
Word 2007 mail merge using Excel 2007 data Munchichic Microsoft Word Help 9 August 7th 09 08:50 PM
Import Excel 2007 cell data into word 2007 fields? Tec92407 Microsoft Word Help 1 July 25th 09 07:58 AM
Word 2007 Mail Merge puts in a space for empty fields from Excel 2 SlowHnds Mailmerge 4 January 13th 09 11:07 PM
Word 2007 Mail Merge Labels skips fields using update fields Dianne Griffin Mailmerge 3 August 8th 08 03:59 PM


All times are GMT +1. The time now is 12:22 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"