contacts

  1. G

    How to automatically remove all unacceptable entries from a CSV file?

    I have an enormous contacts file in .CSV format with about 15,200 entries. Many entries are nonstandard, repeating the email address in the first name field or something like this. I want to automatically remove all of these nonstandard entries and leave all the ones that have a First and last...
  2. C

    add or update contact from Excel to Outlook

    Hello friends, I have very well working code to add contact from Excel worksheet to Outlook, however I am facing problem - want to update the contact if already exists (for instance contact which has same emailadress as the one i have in my excel worksheet). Will somebody help me how to...
  3. S

    Contact list, mailing labels and invoices

    Hello. I am glad I found this forum. I have a problem for which I haven't found a real solution but I am sure there has to be one so here I am praying you guys can point me in the right direction. Firsty of all my knowledge of Excel is intermediate and NONE for macros. I started at a new job...
  4. Z

    Looking for an Access template for professional contacts that focuses on the contacts 'category'

    Does anyone know of any template that focuses first on the techspace and/or category of a contact, and then has contact info? I've found many that have contact info as part of the template but none so far that allows the user to focus on techspace first, contact info second. I'm still a bit new...
  5. C

    Manipulating outlook contacts using excel VBA

    (Bear with me here as I will probably just be spitballing at the start). So I have a list of names that gets updated every so often with contact names and email addresses for companies. Instead of having to do an import, I am trying to automate the process of importing using VBA. Firstly, I...
  6. W

    Printing outlook 2010 contact list with page breaks

    I am using Microsoft Office 2010 trying to print my Outlook Contacts into an Address Book and have hit 3 snags. I would be grateful for your help. 1) I am printing all my Contacts in a “Medium Booklet Style” using the “Double sided or duplex” feature. It works well except it does not start each...
  7. R

    Excel Question Re: Linking?

    My scenario is this... I have about 200 employees. Each working in different departments of the company. In Excel 2007, I have 9 sheets in one workbook. Each sheet can vary from 6 to 40 rows (one row per employee with each row consisting of about 9 columns of contact information). The...
  8. A

    Lookup Outlook Contacts

    I made an excel function that will return employee names stored in MS Outlook by referencing their employee ID numbers. The function works ok, but it's too slow. I'm sort of blathering my way through VBA and could use some ideas to speed things up. Any help is appreciated. Here is what I came...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top