I have got an email with an attached zip file. When I downloaded it to my computer it became a text ed file. This file contacts lots of names and addresses that I would like to make mailing labels for. To do that, I must merge it to excel.
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 have been using Automator to import hundreds of text files into one excel workbook using the "Import Text files to Excel Workbook" action. Automator works great for all files that are tab delimited. However I have another set of data that are output with a varying amount of spaces between each column. I cannot change the way they are output.
Automator gives me the option of choosing "space" as a delimiter, but it wont give me the option to "Treat consecutive delimiters as one" that Import within excel does. I also tried to record my actions within excel many times but it didn't work even with just one file. So what I need is a way to get these text files into one excel workbook as separate worksheets with the data separated correctly into columns.
I searched on this topic and just find old references to "Address Book" which i guess does not exist anymore.Â
I have an Excel worksheet of about 200 names, street addresses, and email addresses, one contact in each row. One column is the email addresses, which is all I want. If I could get the names too that would be nice. Â
I try the Contacts import command, but cannot import the section of the worksheet I want. I don't know what I'm doing wrong. I highlight the contacts column in the worksheet and go to the file with the Contacts import command and find it is "dimmed" -- I cannot click on it.
I have an excel file that I can't delete - any suggestions on how to get rid of it? I can't move to trash, can't open, can't do anything to do. The message I get is "the item B4D19F00 can't be moved to trash because it can't be deleted".
I just used software updater this morning (Oct. 22,2010). Now when I go to open an excel file, it appears to open but doesn't. I can open up other excel files. Other people can open up this same file. I even had someone re-save file with new name, and it still won't open. If I open it directly from Entourage, it will open excel, but not the workbook. The workbook isn't hidden, as I've tried to print and unhide workbook, but it's acting as if there's no workbook open. I think this has something to do with the updated software from this week.
Will my Excel & Word Files work on the newest OS for MAC? I know MAC has Microsoft Word and Excel but if I save all my files to a flash drive will I be able to transfer them to the MAC and will they work? This is why Im nervous about getting a mac.... All my Excel and Word files are the older version of MS OFFICE 97-2003 format.
Just found this and it works really well even on snow leopard. And best of all it's free. [URL:....] I just donwloaded some free patterns to try it out here. [URL:...] Import zip file and activate. Takes 2 seconds. Now if I can only have my old rainbow back that would be nice. I guess that will be the next test to make my own and see if it works. If I extract a pattern and right click and say compress. It also imports. So it works just as the original. So it shouldn't be too hard to make my own designs and rezip them. I just don't remember what info.plist does or how to edit that if I use my own design.
Have tried basic "add file to library", also "import playlist", also starting in Finder and trying to drag to a playlist, and also right clicking 2x in Finder and looking for the window that gives me the option of saving or importing to itunes (???)
i am a new mac user and am slowly starting to get to grips with everything mymcbook can do. I used to have a hotmail account but now i want to use MAC's MAIL. I already managed to get my mails delivered but now i'm struggling with the email addresses. I have managed to export these from my hotmail account to Excel for Mac but would like to get them, nicely ordened in Apple's address book so that i can directly use then in MAIL.
I have been working on an Excel file for the last month continuously saving at every moment.Â At some point something happened and the file name now included a (version 1) after the original file name.Â I didn't worry about that because I was able to work on the file and keep on saving my work.Â I did some changes yesterday and saved it.Â All of a sudden I got a message that there was an upgrade ready to be installed at night.Â So I saved the file and did the upgrade. my file was nowhere to be found.Â I keep looking at Finder and I can only find a file with a similar name not the one with the (version 1) on it.Â I opened that file but it doesn't include any of the changes and updates I have done in the last month.Â I never deleted the file and I have double checked on the Trash and its not there.Â Is there a way to recover my file?Â The only thing that I did differently was that I completely powered of my mac as opposed to just closing it.Â
I am doing a project for my new website where I need to show select clips from movies I have downloaded. The movies are in .avi format and I use VLC to watch them. iMovie will not let me import these videos, how can I work around this? So I can edit them in Imovie.
Is there a limit on the size or length of an audio file that Garageband can import?
I have an Apple Lossless file over five hours long in iTunes. When I try to drag it into Garageband, it acts as though it is importing, but then tells me the ".aiff file is empty". But if I play the file in Quicktime, iTunes and in the iTunes section of Garageband, it plays fine.
I don't do a lot with Mini DV, but I have a mini dv tape that I'm attempting to capture using FCP7.Â Basically when I play the video to a TV off the camcorder, it looks fine, and when I play it in the "log and capture" preview window it looks fine, but when I actually capture it, the video is very pixelated/chunky.Â What am I doing wrong here?Â I notice that in the "log and capture" preview window, there are interlacing/combing lines, and when I play the captured clip, there are not.Â Can FCP7 be trying to deinterlace my footage and butchering it in the process?Â I'd rather have combing than this pixelated mess.Â Â
You can see a comparison in the screenshot here, especially noticeable in this comparison along the roof lines:Â [URL] ...
I have some .numbers files that I need a friend to look at on her pc with Excel 2003 SP3, but it's not working for her. I have changed the extension to .xls but it's no good, as when she tries to open them they are all gobbledegook.
Here's a snapshot of the various files I have, but notice how the icons for each is different, or rather that there are two distinct designs? Some of them DO open in Excel, but some do not.
I work on Excel files through my Office Mac program. On two occasions, a large Excel file, (about 1.5 MB) will not save and is not recoverable. It gives me an error code -43. I work on many such files without problem, but this has now happened on two occasions with important files.