Software :: Microsoft Word 2008 Mail Merge Won't Convert Excel Xlsx File
Sep 27, 2009
Microsoft Word Mail Merge launches a file converter when using Excel files as the data source. Nothing new about that. However, when using Mail Merge in Word 2008 and an Excel xlsx file as data source under OS X 10.6, the file converter will not recognize the file unless the extension .xlsx is actually appended to the file name. The file converter used by Word 2008 still recognizes xls files with or without the extension appended, as did the file converter used by Word X.
I'm running an experiment that will give me a spreadsheet in Excel with 20 participants names, addresses, email addresses, and profits (from the experiment). My goal is to take this data and create individual receipts in Word that have all the above information and can be printed out and handed to the individuals (20 receipts). I have access to Office 2004 (Mac) or 2007 (Windows).
I like to write a personal newsletter, then paste it into emails and send. It's easier for me to work on it in Word first. I can't figure out a format that I can use in Word so that when I copy and paste it in Apple Mail email, it keeps the same format. So far, it changes format when I paste it. what was in bold, is no longer (or the whole thing is in bold), line spacing changes, bullet points change. I tried saving it as pdf file first and the font became microscopic when I pasted it into the email...
I use MacBook Pro, OS X, 10.6.4; Mail Version 4.3 (1081); Microsoft Word 2008 for Mac, Version 12.2.6 (100708)
I am searching for a plugin, software or a solution for a situation I have with an Excel/Word Mail Merge.
It's a law firm we specialize in DUI/DWI and Reckless Driving defense. We subscribe to a data collection service that pulls data from various court systems around the state. We are then given this data by jurisdiction. The Excel files we receive come with 2 workbooks in one file for Traffic and Criminal arrests data with name, address, reason for arrest, etc, etc.
What I have been doing is opening each Excel file and copying and pasting into a new worksheet only grabbing the DUI and Reckless driving arrests because tis is all I am needing from the various files. I then save the new workbook and do a mail merge with Word from this newly created workbook.
Now my question is there such a plugin or software that will combine all the Excel files I receive from the Data collection house and then be able to filter out only the DUI and Reckless Driving arrests to a single Excel Workbook?
I want to upgrade to Mavericks from MAC 10.6 but I am getting a warning that if I do Microsoft Word and Excel will not work because they are PowerPC based applications. Is there any way to get them to work OK if I complete the upgrade?
When I open up a new word doc (doc 1) and start typing randomly with loads of spelling errors the little red line does not appear under the mis-spelled word. When I Manually select spell check it tells me that there are no mistakes even though there blatantly are. If I open up a new blank doc (doc 2) and begin typing away again the same mis-spelled words, the red lines appears as it normally should. This is where it gets weird.......In doc 2 if I go into preferences>spelling and grammar, The boxes, "check spelling as you type" and "always suggest corrections" are ticked under both the spelling and grammr sections. If I then go into the same preferences for doc 1 the same boxes are ticked under the spelling and grammar sections however the grammar section is greyed out so I can't change the settings.
I am currently typing my thesis so having a wacky spell check is driving me insane. What I have been doing is opening a new doc then opening another new doc (doc 2) and typing in that however I have also noticed that the spell check doesn't always seem to work.
Does anyone else find it incredibly annoying that you cannot open an MS Word doc in one space and then go to another space to try to open another doc there without being flipped back to the first space? This seems like a perfectly reasonable thing to want to do - I use Spaces with separate projects not applications.
I've spoken to Apple support and they say it's something I need to take up with MS. I am well aware that these companies have in the past blamed each other for previous incompatibility issues. Do anyone have any insight on these problems before I do contact MS?
When i try to open a specific file in excel or word, very often a number of other recently used documents open up too!All documents were saved prior to closing at last use. Does anyone know how i stop multiple documents from opening up?iMac mid 2011,Office:mac 2011 "WPX" Home and Student all have up to date software?
Info: iMac (21.5-inch Mid 2011), Mac OS X (10.7.3)
My Office 2008 apps (Word / Excel) take forever to quit. When I quit the app, the documents are closed quickly, but then the app stays around for a minute or so, unresponsive, enough to cancel a logout. If I quit the app and wait long enough, it finally quits.
After upgrading to Lion, I can no longer see the text in my word documents or excel worksheets. I know the text is there because it appears in the formula bar - it just isn't visible in the cells. I can also see the text if I quickview the excel files. In the word documents, all I can see are the pictures/images...no text. Weird. I have the latest version of Office 2008 and Lion OS.
I used a standard resume template in Word 2008 Mac that is not displaying properly in Windows. Here is a brief description: On my Mac: The document is perfectly formatted and displayed on 2 pages. On my PC: With ".doc" format, my name doesn't appear. In its place, I have yellow text that reads "address blocked". Additionally, the text spills onto a third page, even though the font, font size, spacing, etc. is all the same.
I then tried saving the document in ".rtf" format, and while my name did appear, the text still spills onto a third page. I cannot fit all the text (in a Windows environment) without cutting out important content. I'm so thoroughly pissed off with this. There should be no compatibility issues in this case because I'm using a STANDARD resume template that came with Word '08. When I saved the document, I made sure to select the "windows friendly" option.
At the moment I do not have Microsoft Office for my mac but I am looking into it as I will be going back to study soon and know I will encounter problems when it comes to transfering documents from my mac to a PC with Microsoft software. However I really love the mac application 'Pages' for personal projects so I am just wondering if I can still use it alongside Microsoft or I must give it up?
By default, I save all my word documents in rich text format (.rtf). After I installed Snow Leopard, these files now open by default with Text Edit.
Since I want these files to open by default in Microsoft Word 2008, I right clicked on the file, chose "other", selected "Word 2008", and then checked "always open with". However, the files still open by default in Text Edit...
I am having a very troubling issue on two different computers. Both run the latest Snow Leopard and Microsoft Word 2008. The problem is the following: Every single time I save a .doc file I end up with a corrupt doc: I can open it only with the computer that created it, and only with Word. No other software (even QL on the same computer) can open it. I have to re-open the doc with Word, SAVE AS, do a compatibility check, ignore all the issues or fix them, then save it with a different name. Then it works. The only difference between the two computers is that with Word 2008 at times I cannot even save it with the workaround I explained above: I have to save as DOCX with compatibility check in order for it to work. This is getting really annoying, as every time I have to send a .doc for work reasons (several times a day), I end up having to triple check it and save it.
After opening a MSfile the Leopard top menu when using Microsoft Word 2008 has been changed to Chinese. This issue only happen with this product and not with the rest of the Microsoft tools that I have installed in my MacBook (example: Powerpoint). I'm including a print screen (as you can see only the iOS menu is changed to Chinese and not the software menu). I extremely need to change it back to English!
I just installed microsoft word....it is a little slow...i.e. the typing shows up a split second after i type, instead of instantaneous...I think because of the spelling/grammar checking. anyone else witness this?
Is there a way to do an e-mail merge? What I mean is I need individualized messages to multiple e-mail recipients. A regular mail merge just creates individual documents which you have to manually address and e-mail.