MacBook Pro :: Turn Contacts Into A Database Using Excel?
Apr 18, 2012
Really need to organize my contacts into groups for a data base using excel .Can anyone tell me where to start please?I have my contacts downloaded in address app and excel loaded .
I have spent the last few hours trying every solution that is supposedly available for converting VCF files to an xls file. WHY can't this be an option in the Contacts program? I need to upload some contacts to Constant Contact. Come on! Really! There must be an answer that doesn't require me to convert two - three times before I can use the files.
I start my Macbook Pro Retina Late-13' Microsoft excel and word always open, I thought this was to do with the login items but when I go to it only chrome helper is ticked and Excel and Word are not there. Is there a option in word/excel to turn this feature off?
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 am running Yosemite 10.10.1 and I use the built in Mail, Calendar and Contact applications. What I would like to understand is if there is a way to disable the function that automatically adds email address into my contact.app without me specifically doing this function myself?
Info: MacBook Pro with Retina display, OS X Yosemite (10.10.1)
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?
1. Turned the List Manager on by accident in Excel. Can't figure out how to turn it off now. I am using Excel 2004, and a MAC mouse - so no right-clicking for me...
2. How do I move columns in Excel? I select the column on top, but then try dragging it to a place I'd like it to move, but nothing happens. How do I do that?
3. General Mac Word/Excel question - how do I get to use "Home" and "End" buttons? When I hit them I simply jump somewhere, but not to the beginning or end of the paragraph. I have a MAC keyboard with the "Home" and "End" buttons along with the "Help", "Delete", "Pg Up" and "Pg Dwn" keys - basically it looks a lot like a PC keyboard...
I have been asked to do a project at work in Excel. I am keeping track of around 7,000 properties all over the United States. My boss wants to know a lot about each one. I am really struggling with the weather part!! I need to somehow pull the temp and if its snowing or raining from the internet into excel. I have all the addresses and zip codes for each property. I was thinking i could write a formula that looks at an RSS feed or website (like yahoo or Google weather) based on the zip code of the address. I could also write the formula that pulls the weather to excel then VLOOKUP the zip. Does anyone have any ideas about this?? I am not sure what to do!!
I have been asked to do a project at work in Excel. I am keeping track of around 7,000 properties all over the United States. My boss wants to know a lot about each one. I am really struggling with the weather part!! I need to somehow pull the temp and if its snowing or raining from the internet into excel. I have all the addresses and zip codes for each property. I was thinking i could write a formula that looks at an RSS feed or website (like yahoo or Google weather) based on the zip code of the address. I could also write the formula that pulls the weather to excel then VLOOKUP the zip. Does anyone have any ideas about this?? I am not sure what to do
I recently purchased my first MAC with Excel for Mac 2008. I am unable to open any files created in it on my PC which has Excel 2003. Apple is of no help. They had assured me of compatibility at purchase citing the new open format. The MAC Excel 08 file won't open on the MAC on which is was created with their Numbers program either.
It seems that the contacts app has suddenly become incapable of accessing my contacts in the cloud. Its fine on icloud.com, its fine on my phone, and its fine on my ipads. However, I'm getting an error message right now which I think must be to do with an update to Little Snitch which I did almost immediately before, and which necessitated a reboot. Since the reboot, I am seeing the following
Of course, this also means Messages doesnt work. LS is not blocking any icloud things, and calendars and mail are still working with no issues.
I'm not exactly sure of where to post this... I'm having a problem with my computer (Address Book, I believe) syncing w/ Google contacts. I'm getting the following error messages:
The first image is the original error that comes up. If I click More Info, it brings me to a list of contacts. The "Before" info contains the correct fields for their email addresses (e.g., school, work, etc). However, Google wants to get rid of these fields.
Is there any way I can get Google to accept this fields? Also, can I have Google revert to my Mac's info instead of the other way around (my mac using Google's changes)
After upgrade software on iPhone (with iCloud) contacts on MAC (Snow Leopard) are no mre sync with iPhone....
As some time hase passed by and I did not notice it immediatly, now I have all updated contacts on iCloud and no moe on Mac; how can I import contacts from iCloud to Mac contacts in snow leopard?
Info:iMac - MacBook Pro - iPhone - Time Capsule - Airport Express, Mac OS X (10.6.6)
Im trying to update to latest version of office on my machin but th einstaller keeps telling me it cant apply the update until i have quit Databse Demon & Sync Services Agent. As far as i can see i have quite all apps except installer so i cant find a way to get out of this cycle.
When I send my .xls files from my Mac (Office 2008) to my boss's Windows machine (Office 2003), he gets an error message when he attempts to open the excel spreadsheet: Excel has encountered an error and must shut down. I've sent files to other computers and not had a problem, and my boss has received other excel files and been able to open them. So it must be something between these two machines/softwares that is affecting it. Any suggestions or ideas? I can add any additional info you need.
Recently switched from PC to Mac, I really miss the F2 functionality in Excel for Mac
Or, more specifically , I am missing the possibility to place the cursor in a cell and hit F2 to edit the formula as well as Excel color-coding all cells that are referred to from the current cell.
I know I can do the same by clicking in the "formula builder toolbar" but I don't wan't to have to reach for the mouse each time... does anyone know if Excel for Mac has a similar feature / keystroke to use
But I can turn it off, if I choose "Share my internet connection for other units". (I don't know, if this is the right text in english, because my OSX is in german)
2) Now Bluetooth is OFF:
But I can't turn it on, because the checkbox "ON" is inactive.
It turns only on, if I choose "New Unit"(?). Then there is a new window, that says, that this is only possible if Bluetooth turns on. If I say OK, bluetooth turns ON.
Back to 1)
What's the problem. Why is this f* checkbox for turning bluetooth on and off inactive?
This is not a hardware problem, because I can have stable bluetooth connections.
I did a smc and am pram reset. But it doesn't help.
1. What are the file extensions for MAC excel? Do they differ from PC excel? 2. What are the differences between MAC excel 08 vs PC excel 07? I have had some work done by a provider in elance in PC excel 07 and now i can not read the spread sheet in my MAC environment. The provider is saying that MAX and PC excel versions are 100% compatible - I disagree and need to know the differences but I am not tech/program savvy.
Can anyone tell me where the Autofill database is located? Every time I use Autofill it has my name mispelled and I want to change it. Also is there a keyboard shortcut to Autofill instead of clicking on Edit then Autofill?