VBA Macro to run email or task from Excel to Outlook

**slohman** · 07-18-2013, 04:15 AM

Can someone help I'm using the below macro but it will not recognise that I have blank rows.

I have due dates Column I some cells are blank because they are not due, I have subject in Column A, I have Body of Email in Column B & Column M

It works fine for the first 10 rows as they have dates but when there is a blank it just doesn't send any further emails. I think I need to change from range to cells but I have tried everything.

Please Login or Register  to view this content.

Thanks in advance

http://www.mrexcel.com/forum/excel-q...ml#post3522523
http://www.ozgrid.com/forum/showthre...116#post675116

**Debraj Roy** · 07-18-2013, 04:44 AM

So..

If .Range("I" & i).Value < Date And Not .Range("E" & i) = "SENT" Then

You still want to send mail.. if
I column is Blank..
Please clarify in which case mail need to send..

**slohman** · 07-18-2013, 04:47 AM

Sorry if column reads sent, skip and proceed to next due date

**Debraj Roy** · 07-18-2013, 06:58 AM

Hi Slohman,

If .Range("I" & i).Value < Date And Not .Range("E" & i) = "SENT" Then

above code is doing the same..

If not SENT and Due date is less than TODAY..

By the way..
add a

Please Login or Register  to view this content.

at the starting of the Module.. so you dont have worry about Sent & SENT

VBA Macro to run email or task from Excel to Outlook

LinkBack

Thread Tools

Rate This Thread

Display

VBA Macro to run email or task from Excel to Outlook

Re: VBA Macro to run email or task from Excel to Outlook

Re: VBA Macro to run email or task from Excel to Outlook

Re: VBA Macro to run email or task from Excel to Outlook

Thread Information

Users Browsing this Thread

Similar Threads

Create Outlook task from Excel Macro?

Create an Outlook Email and or Task based on a due date.

Recurring Task / Delayed Email in Outlook 2010

Excel to Outlook as Delayed Email (was Task) (was Calendar)

Bookmarks

Bookmarks

Posting Permissions