Mac Mini :: How To Import TextEd File To Excel

Mar 20, 2012

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.

Info:
Mac mini (Early 2009), Mac OS X (10.5.8)

View 1 Replies


ADVERTISEMENT

Applications :: Using Mac Excel - Merge/Filter/Extract Into A Single Excel File?

Feb 6, 2009

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?

View 6 Replies View Related

Final Cut Pro X :: Don't See Import From IMovie Under File / Import

Aug 30, 2014

I don't see "import from imovie" under file/import

Info:
MacBook Air (13-inch Mid 2013), OS X Mavericks (10.9.3)

View 6 Replies View Related

OS X Technologies :: Automator - How To Batch Import TXT Files Into Excel

Mar 6, 2012

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.

Info:
MacBook, Mac OS X (10.6.8)

View 1 Replies View Related

Intel Mac :: Any Way To Import Address Book To Excel Spreadsheet?

Apr 5, 2012

I would like to transfer my contacts from address book to an excel spreadsheet. Is this possible.

Info:
iMac (27-inch Mid 2011)

View 1 Replies View Related

OS X Mavericks :: How To Import Excel Column Of Email Addresses Into Contacts

Aug 28, 2014

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.

View 2 Replies View Related

Applications :: Saving As A Gif Or Jpf File From Excel?

Mar 18, 2009

From an Excel spreadsheet I've created a graph using the chart wizard. Is it possible to save a copy of that graph as a gif or jpg file?. If so, I'd appreciate some instruction on how to do that.

View 2 Replies View Related

MacBook Pro :: Have An Excel File I Can't Delete

Feb 8, 2012

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". 

Info:MacBook, iOS 5.0.1

View 1 Replies View Related

Mac Mini :: How To Import .bkf Files

Apr 11, 2012

I am trying to import backup files from a storage drive into my mac.  What is the trick to doing this?

Info:
Mac mini, iOS 5.1

View 4 Replies View Related

OS X :: Updated Software Now Cannot Open Excel File

Oct 22, 2010

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.

View 6 Replies View Related

OS X :: Compress Pictures In Excel File While Saving?

Apr 24, 2009

how to compress pictures in an excel file while saving it on my mac?

View 1 Replies View Related

Software :: Mac And Excel File Transfer From Windows To Mac

Dec 1, 2009

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.

View 3 Replies View Related

Intel Mac :: Recover A Deleted Excel File?

Apr 27, 2012

recommend a trusted software program to recover a deleted excel file, or know of a way to recover a file without downloading an additional program? 

View 2 Replies View Related

MacBook Pro :: Send A Numbers File To Someone Who Has Excel?

Jun 20, 2012

how can I send a Numbers file to someone who has excel

Info:
MacBook Pro, Mac OS X (10.6.8)

View 1 Replies View Related

OS X :: Import Zip File And Activate

Oct 5, 2009

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.

View 3 Replies View Related

ITunes For Mac :: Import WMA DVD File?

Jun 5, 2014

Can I  import a WMA file (audio) to itunes (or how do I change the file name to mp3) ?  I  ultimately want to  download it to my ipod.  Or is there another app that I can work with (WMA player(?)

Info:
iMac, OS X Mountain Lion (10.8)

View 1 Replies View Related

ITunes For Mac :: Cannot Import MP3 File

Jun 5, 2014

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 (???)

Info:
iMac, OS X Mountain Lion (10.8)

View 1 Replies View Related

Mac Mini :: How To Import VHS Tape Into System

Jan 27, 2010

What wires or hook ups do I need to import this VHS tape off a newish Sony VHS/DVD player into my 2009 Mac Mini?

View 3 Replies View Related

Mac Mini :: Import ITunes From My MacBook?

May 10, 2012

I want to set up my 2006 mini with iTunes from my macbook. What is the best way to import or migrate it to that is is complete with playlists and podcasts etc?

Info:Mac mini, Mac OS X (10.6.8), 2006 upgrade using Snow Leopard

View 1 Replies View Related

MacBook Pro :: Office 2004/Excel / Can't Open File Now

Oct 28, 2010

I was previously using Excel with no problems, then installed updates Tuesday, now can't open .xls file last used Monday?

View 2 Replies View Related

Applications :: Export Excel File To Mac Address Book?

Apr 18, 2009

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.

View 1 Replies View Related

OS X V10.6 Snow Leopard :: After Upgrade, Cannot Open Excel File

Mar 18, 2012

I just upgraded to Snow Leopard, am running 10.6.8.  My old excel files In MS Ofc for Mac will not open as Excel, rather they do in "Numbers."  How do I view and update my old spreadsheets?

View 4 Replies View Related

MacBook Pro :: Lost Excel File With System Upgrade

Sep 1, 2014

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. 

Info:
MacBook Pro

View 2 Replies View Related

Applications :: How Do I Import An Avi File To Imovie

Nov 9, 2010

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.

View 4 Replies View Related

Applications :: ICal Can't Import Ics File

Nov 9, 2010

I'm trying to import an ics file (made by a website) in ical.

When I'm trying to import it, iCal asks me in which calendar but when I click OK, i get the following error:

iCal can't read this file. there are no activities added... (or something like that, i translated it from dutch).

View 5 Replies View Related

Applications :: Can't Import A Certain File To Garageband

May 17, 2010

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.

View 2 Replies View Related

Final Cut Studio :: Pixelated Mini DV Import

Jun 30, 2014

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] ...

View 2 Replies View Related

Applications :: Opening A Numbers File In Excel Won't Work With Extension Of .xls

May 18, 2010

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.

View 4 Replies View Related

OS X V10.7 Lion :: Automator To Save Word / Excel File To Two Different Directories

Mar 22, 2012

I'm a new Mac user and was just reading about "Automator" My question is would it be possible to create a workflow etc, to save an excel or word file to two different locations or directories?

Info:
iMac, Mac OS X (10.7.2)

View 5 Replies View Related

OS X V10.5 Leopard :: Large Excel File Not Saved Neither Recoverable On IMac

Jun 5, 2012

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.

Info:
IMac 10,1, Mac OS X (10.1.x)

View 4 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved