Results 1 to 22 of 22

Finding values entered in a column TODAY by the same user

Threaded View

  1. #1
    Forum Contributor
    Join Date
    08-24-2012
    Location
    Hollidaysburg, Pa
    MS-Off Ver
    Excel 2010
    Posts
    398

    Finding values entered in a column TODAY by the same user

    • I have column A fully populated with values
    • I have a macro that when clicked, opens outlook express and sends an email to a vertical head with the latest entry # in column A.
    • No issues at all. Works fine. But I want to upgrade it
    • Is there a way to find out the values populated by a given user, in a particular day, in this case, today ?


    For eg:
    • If XYZ populated, Range A7,A8 and A9 yesterday.
    • Today, ABC populated Range 10,11 , 12 and 13:
    • Then the code today, should send an email to the vertical head saying , Range10,11,12 and 13 were updated today.

    My code uses the following :
    For finding last value in row :
    Range("A65536").End(xlUp).Value

    Code that sends the mail

    Set oout = CreateObject("Outlook.Application")
    Set omsg = oout.CreateItem(0)
    Dim ireply As String
    Dim LastRow As Range
    Dim SigString As String
    Dim Signature As String
    ireply = MsgBox(Prompt:="Is your OUTLOOK open ?", _
    Buttons:=vbYesNoCancel, Title:="UPDATE MACRO")
    
    If ireply = vbYes Then
    'LastRow = Cells(Rows.Count, "A").End(xlUp).row.Value
    
    With omsg
    .to = "edf@gmail.com"
    .CC = "elf@gmail.com "
    .BCC = ""
    .Subject = "Customer Service - Request ID # " & Range("A65536").End(xlUp).Value & "  added"
    .Body = "Dear edf," & vbNewLine & vbNewLine & " Customer Service Department just added  Request ID #  " & Range("A65536").End(xlUp).Value & "  to the list" & vbNewLine & "Due Date is :  " & Range("L65536").End(xlUp).Value & vbNewLine & vbNewLine & vbNewLine & "Thanks and Regards"
    .Display (True)
    
    End With
    ElseIf ireply = vbNo Then
    MsgBox ("Alright ! I will open that for ya ")
    Shell ("OUTLOOK")
    With omsg
    .to = "edf@gmail.com.com"
    .CC = "elf@gmail.com.com"
    .BCC = ""
    .Subject = "Customer Service - Request ID # " & Range("A65536").End(xlUp).Value & "  added"
    
    .Body = "Dear edf," & vbNewLine & vbNewLine & " Customer Service Department just added  Request ID #  " & Range("A65536").End(xlUp).Value & "  to the list" & vbNewLine & "Due Date is :  " & Range("L65536").End(xlUp).Value & vbNewLine & vbNewLine & vbNewLine & "Thanks and Regards"
    .Display (True)
    
    End With
    ElseIf ireply = vbCancel Then
    Exit Sub
    End If
                        '  If omsg.Sent Then   ' // HAVING ISSUES WITH THIS AS ON 10/30/2013...
                        '      MsgBox ("Sent")
                        '  Else
                        '     MsgBox (" Not Sent ! ")
                        '  End If
    Set oout = Nothing
    Set omsg = Nothing
                        'Exit Sub
                        '
    Last edited by subbby; 12-19-2013 at 03:50 PM. Reason: SOLVED

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Finding the nearest date in a column with reference to today
    By lenare in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-24-2013, 10:51 AM
  2. [SOLVED] How to filter specific values entered by user in array
    By shardin in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-03-2013, 02:37 PM
  3. Open a excel userform with values previously entered by user using VBA
    By anuraag1 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 01-17-2013, 07:02 AM
  4. Link returned recordset with a user entered column
    By TheCyrusVirus in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-15-2010, 07:10 AM
  5. Finding all dates in a column that are in the range today to a week from now
    By jrcream in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 10-01-2008, 09:32 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1