Send email from excel based on a condition (outlook 2007)

Status
Not open for further replies.

sn152

Member
Outlook version
Outlook 2007
Email Account
Exchange Server
Hi All,

I have a workbook which has data upto column N.

Column J has got the email IDs.
Column A has got the Item IDs.
Column M shows the age if each item ID.
Column N shows whether the age of item ID is greater than 1.

Now what I want to do is to automatically send emails for the Item IDs which have the age greater than 1 to the respective persons email ids listed in column J.

If one person is working on multiple Item IDs only single email should be sent listing all the Item Ids worked by that person.
Note: Email IDs might change everytime.


Please help me on this.

Thanks in advance.
 

Diane Poremsky

Senior Member
Outlook version
Outlook 2016 32 bit
Email Account
Office 365 Exchange
If one person is working on multiple Item IDs only single email should be sent listing all the Item Ids worked by that person.
This would be the hard part. Creating the message and checking the age is easy - a basic macro is here http://www.slipstick.com/developer/code-samples/create-messages-using-data-excel-file/ and you'd start with an if statement checking the value in column N.
Putting them into one message per id could be done one of several ways - these are two that come to mind immediately.
1. sort by id and only start a new message if the id changes
2. loop through the sheet and look for a specific id - this would work best if you had a separate list of id's or marked off each record as used. The loop could check for unused records, then look for matching ids.
 
Status
Not open for further replies.
Similar threads
Thread starter Title Forum Replies Date
M Extract all links from Outlook email, send to Excel Using Outlook 2
D send email from Excel using outlook template Outlook VBA and Custom Forms 3
D Outlook VBA to open Excel attachment and send recipient's email address to a workbook cell? Using Outlook 4
glnz O365 - How to send from acct 2 but showing email name from acct 1 as From - alias? Using Outlook 0
T After I send a new email, it remains in the Draft folder Using Outlook.com accounts in Outlook 3
S Change VBA script to send HTML email instead of text Outlook VBA and Custom Forms 3
M ERROR: None of your email accounts could send to this recipient Using Outlook 2
J Add an Attachment Using an Array and Match first 17 Letters to Matching Template .oft to Send eMail Outlook VBA and Custom Forms 2
ChrisK2 Send email to advertise@slipstick.com fails: "The group advertising isn't set up to receive messages from..." Using Outlook 3
R auto send email when meeting closes from a shared calendar only Outlook VBA and Custom Forms 2
X Unable to send an email from one account to another on same PC Using Outlook 2
M VBA to send reminder email if no response Using Outlook 13
D Using a VBA Custom Form to Send Reoccurring Email Upon Task Completion Outlook VBA and Custom Forms 4
M Can't send email in outlook.com Using Outlook 9
B When working on emails in a certain folder, when I hit reply or reply all, I would like it re always reply all and add an email address to send to Outlook VBA and Custom Forms 3
A Outlook - Send New 20 Attachments through Email Using Outlook 4
S Send email via SMTP - use transport rules to add to senders inbox (then rule to move to sent items Exchange Server Administration 1
R Prompt asking the user to send email to folder as *.msg file Outlook VBA and Custom Forms 1
D Is it possible to automatically send an email when it is moved to a folder? Exchange Server Administration 1
Diane Poremsky How to Send Email When Traveling or Using Public Wi-Fi New Slipstick.com Articles 0
B VBA Help Email that will save as draft and send as attachment Outlook VBA and Custom Forms 3
A Automatically send email based on drop-down field? Outlook VBA and Custom Forms 2
H send reminder if no reply received on first or original email using macro Using Outlook 2
K Macro Not Executing then send email from Explorer Outlook VBA and Custom Forms 3
A Block user to send emails to specific set of email ids Using Outlook 1
T Can't send email through connected account (outlook.live.com) - goes to Drafts folder Using Outlook.com accounts in Outlook 3
C Custom Application Form send Email to Another User Using Outlook 1
C Macro to send email after changing from address and adding signature Outlook VBA and Custom Forms 1
M Send an Email When a Reminder Fires Outlook VBA and Custom Forms 1
Diane Poremsky Send an Email When You Add an Appointment to Your Calendar New Slipstick.com Articles 0
Diane Poremsky Send email to all addresses for one Contact New Slipstick.com Articles 0
G "Delay Delivery" Email fails to send if opened while in Outbox Using Outlook 4
E Send a Reminder/Task to certain Email Recipient Using Outlook 5
Diane Poremsky Send an Email When a Reminder Fires New Slipstick.com Articles 0
A Send email from BCM BCM (Business Contact Manager) 5
T Using a macro to send email to diffrent address Outlook VBA and Custom Forms 1
V Outlook 2010 – Send email based on categories Using Outlook 2
M Use a macro to send files by email Outlook VBA and Custom Forms 3
S Can't send messages using Outlook 2007 from a business email Using Outlook 3
C outlook 2013-how do i send email to myself? Using Outlook 1
K Struggling to send team email Using Outlook 1
H Problems With Outlook 2013 VBA To Send and Print an email Outlook VBA and Custom Forms 1
R Outlook 2010 Send from other email address uses account address instead Using Outlook 1
R Email Send & Receive Turned off but sends automatically anyway Using Outlook 1
A Application_ItemSend not accessed when sending email outside outlook (i.e. word or send to mail from Using Outlook 7
R Outlook 2013 cannot send email error 0x700700c1 Using Outlook 1
SirFishAlot Send atachment with mass email using BCM, and Publisher 2013 BCM (Business Contact Manager) 1
A In email, tab sequence and Shift-S for send Using Outlook 4
K can't send email to other domains Using Outlook 1
V Cannot send email to group Using Outlook 12

Similar threads

Top