Search results

Hi all, I have an excel file full of emails to be checked. Those emails are the ones to be flag marked as complete in outlook contact file. What I want to do is a macro that can scan through the excel file and compare to a contact folder in Outlook so that when the email matches a contact file's...

So this macro would have each email sent one minute after the previous one? Where would I execute the macro? Which of the utilities at Mass Mail Tools for Outlook takes care of this?

Yes, how can we tweak it to work with a CSV?

How about one that operates not with email messages but with contacts? For instance, if I highlight three contacts in my Contacts folder, and want to create a DL for them?

Pretty sure I didn't ask about that. Yeah, if you have one for CSVs that would be amazing.

Have to preface this by apologizing for all the posts. I'm just in the process of expanding our database dramatically and... it's a lot. I appreciate all your advice over the years more than you know. BTW, is there a way to donate to the site? Would be worth every penny. I know about the delay...

Hey all. i have a ton of outlook contacts that need to go into contact groups. Is there any kind of code to speed this up? In a perfect world I'd like to highlight, say, four contacts, run the code and voila - a contact group is created and they're all thrown in. Wishful thinking? Thanks as...

I have a CSV of email accounts who have unsubscribed from my emails, and I'm trying to get their corresponding Outlook contacts out of my database. Is there a code that will move them to the Deleted Items folder? Or at least mark them for deletion so I can find them and fish them out of there...

Leaning towards doing it manually. Sigh..

Are you basically saying start all over again? I'm hoping there's a way to marry that data with those contact files I created since I worked so hard on them. I figured there might be no way though. Is that the case?

This one is a doozy. I've been throwing you problems for years but this one is rough. Just imported 4.5k contacts from a csv into outlook forms. Custom outlook forms I created. The csv has a column called Genre which we mapped to User1 in the contact forms. Once the forms were created we ran...

Great! It worked. Thanks alot Diane.

Yes, I've tried changing to Email2 and Email3. There are around 60 emails that weren't found. Check out my last reply.

Ah, now I got it. It can't find certain addresses that has "." before the "@" in the email address. For instance, emails like ace.falcon@gmail.com cannot be detected by the macro. Please advice me.

No problem. Now the macro works fine. But there's one more thing, my .csv file has 530 addresses but I only got 469 addresses in the Delete category. I've tried changing this part Set myItem = myContacts.Find("[Email1Address]=" & strAddress) The [Email1Address] to [Email2Address] and...

Thanks for that. But it's still not working. I guess the arrangement of this line is the problem: Set myContacts = cFolder.items Because when you asked me to replace the Do Until Trim until the end, the line above will be deleted as well. May I know where should this line be?

Nope, I made another folder just for cleaning operation.

I've tried changing all the required changes. Still, I think my Excel hasn't access my Outlook contact folders. What would be the correct way to input the FolderPath as an Outlook contact folder? I'm currently using Outlook 2013 and Excel 2013.

Thanks alot for the macros. Right now I have a .csv file which contains one column of invalid email addresses. How should I change the macro so that Outlook can read the file source of that .csv file and compare to a contact folder in my Outlook? From that, I should be able to categorize which...

Hey all. So I just sent my database of 25k contacts through an email verifier which spat back a list of 500 emails that are invalid. I want to get the corresponding Outlook contact files out of there obviously. Is there a way to do this in any other way but manual? Bonus points if you can also...