Windows On Mac :: Mail Merge - Trying To Split Data From Excel To Word Documents
Jul 1, 2009
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).
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 have loaded windows 7 and parallels. I want to load MS office so I can send properly formatted excel and doc files to my client. They say the numbers conversion does not translate well to Excel and pages to word. Do I load MS Office in the windows OS? How can i access the numbers file in the Mac OS to use in the Windows OS on Excel? Is this a better option than loading Office for Mac? I need the formatting that I put into the excel file lto hold.
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)
I am attempting to do a mail merge between word and spreadsheet, and would like some pointers.
I have written a cover letter and would like to import my addresses from a spreadsheet file so that when I print I can insert the different names/addresses into the cover letter & save time.
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.
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?
create a MS Word Mail merge doc using contacts from Mac Mail Mac Book Pro MacOSX 10.5.8 MS Word 2008 for Mac (12.2.0)I've created many MSWord merge docs on Windows using Outlook, Excel and Access, but this is my first attempt on the Mac. How do I get MS Word to read the list of Mac Mail contacts?
How do I set up my mbp to open documents with Microsoft Word 2003 "always" under VMWare Fusion? I tried to set it up but it is not an option/can't figure out where Microsoft Word 2003 is when I right click and go "Open With." It says Microsoft Word 2003 - Boot camp partition but I want it so that it "Always Open with" Microsoft Word 2003.
I'm new to MacRumors. I just installed IWork on my new 13" MBP (has Snow Leopard) and have been unable to open Word 97 documents that I've been emailing myself from work and saving to a flash drive. I have not had such problems with my IMac using Pages.
I handle a bit of finances at a small business. Each week I pull out a report from a web-based economy system. That then opens in Excel. What I'd like to do is simple:
1. The first week I pull the report and mark some stuff on the Excel page (for example highlighting certain debitors, making comments, color fills etc.) 2. The following week I pull the report again, and now I'd like to merge the two together. That is, keep the data from week 1 (or replace parts of it, if that's relevant) and simply add the data from week 2 onto that same sheet, so all information is right there.
I thought that would be a no-brainer. Now I've tried to merge workbooks, consolidate data, looked at tutorials on youtube, read forum posts - the lot, and I still can't get it to work. (Brain possibly smaller than I thought).
I have a MacBook. Last week I bought Microsoft Office for Mac. I would like to open documents sent in Word to be opened in Word. But my mac converts them to Pages.
Info: MacBook, Mac OS X (10.7.4), Microsoft Office for Mac
I have about 40 documents I'd like to merge into one huge document. How do I do that all at once? I don't want to open them individually and merge them into the document one by one.
All of a sudden Word and Excel won't open any more. I just get a message that says "Microsoft Word has encountered a problem and needs to close. We are sorry for the inconvenience."
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?
Mobile Me provided the facility to replace all data on a device from the data on Mobile Me. I have updated my contacts on my iMac. I let iCloud update my newer Mac Book Air but ended up with duplicates Now I want to update my Mac Book Pro which hasn't been used for 4 months and contains all the old contact information I edited off my other two machines. iCloud says the contacts data from my MBP will be MERGED with the data on iCloud. That suggests I will be letting myself in for a complete re-edit again and repeating work already done on the other devices.
Info: iMac / Mac Book Pro / iPhone2, Mac OS X (10.5.7)
How do you make the documents larger in Excel with the iMac? I have tried to change font size, view larger, etc. I still am unable to get the look I get from myPC.
I need to merge about 17 excel files. All have the same headers and are data from different individuals on the same topics.How can I merge into 1 master file without cutting and pasting all 17 files into a master. Also would be great to be able to break out new spreadsheets by individual columns. ( i.e. Location, Part Number , ect ). A friend wrote a little program for me that worked when I was using a windows based machine, but will not work in the Mac environment.
Im going to be purchasing a 13" Macbook Pro but coming from using a PC my whole life I have a few questions:
Firstly would you recommend iWork or Office? And can iWork read and edit work documents?
Secondly, If I am creating a Word document on my Mac and then send it to someone that is using Office on a PC will the formatting etc be the same? Im thinking of the scenario if I am filling out a job application form and then send it to the employer I don't want the formatting to be messed up since that would preclude me from getting an interview most likely. Also, are there any other compatibility issues I should be aware of with sending things between Mac and PC? I know if these will be problematic I can always install Windows 7 via Bootcamp, but id rather they were do-able on OSX.
Does anyone else have problems copying figures (charts) made in Excel into Word? When I copy the figures into Word, they appear ok on a MAC, but when viewed on a PC, the y-axis disappears. I am using Office 2004
Yesterday morning I was using MS Word and Excel and they were fine but then I closed my computer and opened it 15 minutes later and they wouldn't launch. I made additional space available on my drive (90GB now) and ran Disk Warrior to fix permissions and check the hard drive. Today I am still having hte problem. I was able to get Word to open up a blank document but then it immediately crashed. I am trying to figure out if I can solve this without having to reinstall as my installation disks are several years old and I don't have them with me. I am running OS X version 10.5.8 on a MacBook Pro 5,1 My error message for excel is the following:
Process: Microsoft Excel [240] Path: /Microsoft Office X/Microsoft Excel Identifier: com.microsoft.Excel Version: 10.0.0 (10.0.0) Code Type: PPC (Translated) Parent Process: launchd [69] Interval Since Last Report: 358 sec Crashes Since Last Report: 5 Per-App Interval Since Last Report: 7 sec Per-App Crashes Since Last Report: 3...........
I am contemplating upgrading my MacBook Pro (2011 model) from Snow Leopard to Lion. I am concerned about the level of strong criticism about Lion, especially the comments that MS Word and Excel (and Powerpoint?) cannot run in Lion. What is the full story? Can I run MS Office products by reloading them into Lion environment?