emails

Hi everybody, I've been trying to configure my excel spreadsheet to send a short email notification to colleagues when a certain value is detected. However, my organisation wouldn't give me the SMTP server address. I've been reading about this topic but I get the sense that it is not possible...

I have this formula that extracts emails from a string in a row, this works fine. I need this to run on a command button so when the command button is clicked, the formula is pasted into column B as main times as there are rows in column A with data e.g column A has 200 rows of data, formula...

Hi Please Help me with this I have an Excel with Sheet named BUSINESS - which contains the complete Contact database of 258393 + Records and Email in Column K I have an another Sheet Named Bounced , This contains a list of 7000+ Emails that have bounced back . I wanna remove those Emails...

Hi, I have a macro that pulls emails from Outlook Express into Excel. It can only pull emails from my personal inbox though. How can I adapt it to pull emails from a shared inbox? Dim OutlookApp As Outlook.Application Dim OutlookNamespace As Namespace Dim Folder As MAPIFolder Dim OutlookMail...

I am looking for a VBA solution to limit the number of cells that can be copied at one time within a workbook. The data contains emails and I am needing to secure them to where only one can be selected at any given time. Any solutions?

Hi All, This is the first time I'm posting on this forum and I'm a Macro dummy right now so I need some help. I have a list of 200+ emails which I would need to send individual emails to as they require different attachment for them. Here is what I have: Column A - To Email Column B - CC...

Dear Experts, Column A Name of the Person. Column B "To" email address Column C "Cc" email address Column D "Subject" of email. Column E "Body of Email" - will have 15 - 20 lines so break of lines will be there. Column F "Attachment Path" Above database will be in Excel and one single button...

<tbody> Hello everyone can you please help me in my problem, how can i Compare two lists Containing each email addresses and Delete the matched Emails addresses from the first list, the main list is L1 and the second list in L2 which contains...

Hi, I am exporting from a database to an excel file, and will need to clean up some fields in the excel file before I can upload that data to a different database. in one particular cell on the exported file, where I have listed the names and emails of the company contacts, there is a value...

Hello Guys, I've been having a little trouble lately where whenever I receive emails (with excel tables) the data in the 1st column (pasted in the email) shows blank. However, when I copy the data from email to an excel file, I'm able to see the missing data. Here's a snip...

I would like to use my flagged email list to build a to-do list in excel. I need an excel macro that can: 1. Go into outlook (not sure how to tell it to reach from excel to outlook) 2. Find the messages in Outlook that are flagged 3. Copy the subject line, and date that I have set to...

I have created a macro button on the outlook and I'm trying to have it do the following and nothing is working. Much help is needed. When pressed a text box should show up and have 5 choices to choose from. whatever choice is selected will add that corresponding email to the cc line Problems...

Hi Friends, Is it possible to create drafts/ Marked as sent emails without sending emails using VBA. I have list of emails in excel sheet in ColumnA, Where I want to create draft emails "From emails" picking from excel sheet to "From Address field" Does not matter any text in subject line...

Hi I'm sending emails as CDO using Ron's code. I need to hide the emails from my staff as it contains financial information about the company. Emailing works fine but now is doesn't hide the "0". And looks very cluttered. I've turned it off from being displayed. But need to clean it up in the...

So were a tiny science company and I'm trying to help out 'sales' department girl by setting up a macro that will simplify her job a bit... She has a ton of emails and a list of customers who want to be removed from the email list. I'm trying to automate this for her.. I found some stuff out...

Hello, In Sheet1, Col A and Col B has list of emails based on user's role. Sheet2 has just a handful of emails, about 2000. I am trying to write a formula that tells me if either of the emails exists in the lists of emails from Sheet2. For example, if I just need to see if email from Cell A2 in...

Hey, Can send emails fine through VBA but can't work out how to send to an Outlook Distribution List e.g. "Team" = AAA <AAA@AAA.com>; BBB <BBB@AAA.com>; CCC <CCC@AAA.com>; DDD <DDD@AAA.com> I can input the emails into VBA which is fine but would have to add to every macro if I need to add in...

Greetings, just wondering if something is possible. I have used VBA to send emails containing the contents of worksheet cells, but I have never sent an email from a userform before. Has anyone ever tried to send an email from a userform where the email would contain the values from some of the...

Hi I'm hoping some macro expert can help with this issue. I've been trying to find a solution to this for quite a while, but with no success. I do think it is possible with vba. I need a macro that looks in a folder and emails each file in there, individually, to one email address. Seems odd...

Hi All, not sure this is the right place but...I have a bunch of very old email addresses that I have entered into a data base for a local non-profit. Most of the emails are probably bad but I can't tell. I have Gmail and or Yahoo but neither of them have any kind of feed back to let me know if...