Recent content by TylerK

  1. T

    Macro to find contacts by category and copy them to another folder

    Sub Export_OutboundEngine_Contacts() 'SelfCert Instructions: http://www.howto-outlook.com/howto/selfcert.htm Dim ContactsFolder As Outlook.Folder Dim ContactItems As Outlook.Items Dim ResItems As Outlook.Items Dim sFilter, strCategory As String Dim iNumRestricted As Integer...
  2. T

    Macro to find contacts by category and copy them to another folder

    Excellent! that worked great! Since this exported list is meant to be an email distribution list, is there a way to skip the contacts that don't have emails listed in the emailaddress section? Thanks!
  3. T

    Macro to find contacts by category and copy them to another folder

    This seems to work great for the most part! I'm not getting the correct birthday-day, birthday-month and birthday-year values. Any suggestions? Also, is there an easy way to add the appropriate column headings? 1) email 2) fname 3) lname 4) company 5) phone 6) bday 7) bmonth 8) byear 9)...
  4. T

    Macro to find contacts by category and copy them to another folder

    Just added the Scripting Runtime reference and I believe it's working. I'll test some more and will report back. Thanks so much!
  5. T

    Macro to find contacts by category and copy them to another folder

    Thanks so much! I'm giving the last suggestion a shot and am running into an issue. The alert says "Compile Error: User-defined type not defined" Then highlights the text that I've underlined below. any thoughts? Sub SaveContactsinFile() Dim ContactsFolder As Outlook.Folder Dim...
  6. T

    Macro to find contacts by category and copy them to another folder

    Thanks so much for the quick reply! This will be an exercise that will be done frequently and by several users that aren't very tech savvy. That said, a macro is perfect and what you sent works great! This is greatly appreciated! I don't mean to take advantage, but if you're up for...
  7. T

    Macro to find contacts by category and copy them to another folder

    Hello, I'm having trouble finding the answer to my issue and am hoping for some help. I'm looking for a way to search my contact folder in Outlook for contacts in a certain category and ultimately export just those contacts into an excel workbook or CSV. I figured the code would search...
Back
Top