Email notification including specific cell data

S

steve

Hello,
I'm using a spreadsheet to keep track of clients who bring required
tax information to our firm for processing. This is simple log
consisting of the following pertinent columns: client name, client
num, date received in office, accountant responsible for this client,
as well as some notes that I'm not so concerned with. So, I'm
attempting to send an email notification to the "responsible
accountant", upon population of "date received" column, containing the
"client name" in the body of the email.
So far, I've been able to send a general notification to one
distribution address & just let them check the spreadsheet on their
own, but I know there's a way to pull the cell data into the email,
which I haven't been able to figure out. I've used the Sub Mail_CDO
from Ron Debruin's site...here's the code I'm using to do this...

Sub Mail_CDO()
Dim iMsg As Object
Dim iConf As Object
' Dim Flds As Variant
Set iMsg = CreateObject("CDO.Message")
Set iConf = CreateObject("CDO.Configuration")
' iConf.Load -1 ' CDO Source Defaults
' Set Flds = iConf.Fields
' With Flds
' .Item("http://schemas.microsoft.com/cdo/configuration/sendusing") =
2
' .Item("http://schemas.microsoft.com/cdo/configuration/smtpserver") =
"my email server"
' .Item("http://schemas.microsoft.com/cdo/configuration/
smtpserverport") = 25
' .Update
' End With
With iMsg
Set .Configuration = iConf
..To = "(e-mail address removed)" 'My distribution address
..CC = ""
..BCC = ""
..From = """SCHEDULE LOG NOTIFIER"" <[email protected]>"
..Subject = "SCHEDULE LOG HAS BEEN UPDATED"
..TextBody = "TESTING" & vbNewLine & vbNewLine & _
"Client info has been added to the Schedule Log"
..Send
End With
Set iMsg = Nothing
Set iConf = Nothing

So, as you can see I'm no programmer, but think I understand the
basics...just don't know the code I need to reference the spreadsheet
cell data to populate the body & sendEE's email address. I did go
ahead and concatenate the "responsible accountant" name w/our domain
to create a column of email addresses also...just reaching for
anything I guess.
Well, thanks in advance for any & all information you might provide.
Sincerely,
Steve Schofield
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top