Word - Using Excel 2007 to Merge Data to Word 2007 - How to Update Fields
Asked By johnnygx
08-Feb-10 12:03 PM
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.
Excel 2007
(1)
Word 2007
(1)
Doug Robbins - Word MVP replied to johnnygx
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
copy and paste text crashes word Word If I copy text from Textedit or a pdf (using Preview) and then paste that text into Word it will crash. Once that happens I have to log out of OSX and come back before Word will run without crashing (it will open and as soon as I enter a keystroke or select a menu it crashes). Copy and pasting from within word is fine. Running the latest version of Office 2008. Any thoughts? MAC Office Word Discussions CFRunLoopRunInMode (1) Microsoft Excel (1) Microsoft Word (1) RunCurrentEventLoopInMode (1) CFRunLoopRunSpecific (1) ACTIVBoards (1) Word 2007 (1) Office (1) What version / update
How to update a link field with preserve format using VBA? Word HI All, How to update a link field with preserve format using VBA? Anthony Word VBA Discussions ActiveDocument.Fields.Count (1) Office 2007 (1) Word 2007 (1) Excel (1) Vista (1) Word (1) LinkFormat.SourceFullName (1) Application.DisplayAlerts (1) Without knowing more about what you are trying your document. If, as your e-mail address suggests, this is a link to an Excel range then I suspect your concern may be more to do with maintaining the formatting
Can I get menus in 2007 Word Is there any way to get a menu bar w / word 2007? I like 2007 but the choices in the tabs are not sufficient and I have to fight to get the function I need. thanks john Word New Users Discussions Microsoft Word (1) PowerPoint (1) Publisher 2007 (1) Office 2007 (1) Word 2003 (1) Word 2007 (1) Excel (1) Word (1) Add
two documents with the same name" problem and how to trap the error in VBA. Word Hi All, I am wondering if anyone has a solution on this. There is a Word 2007 file (docx) that has links to an Excel file. They are both resided in the same folder. When the files are moved to folder, the link path does not get updated = 96 which I understand. But when the Word file is first opened, the following message came up: A document with the name "xxx over 100 files like that and some may contains hundreds of links. (Also, when the Word docx is opened, Excel also came up in the background - as shown in the Windows Task Manager.) The problem would occur whether the Excel source file is opened or not. When I save the 2007 docx file into 2003
Open correct version of Excel in Word Word I have Word 2003, Excel 2003 and as of today Excel 2007. In a Word macro, I am using: Set myExcel = GetObject(, "Excel.application") and if that errors because Excel