[mso] Based on a criteria in Excel send a letter to recipient
- From: "Scott-Johnson, Tiffani D." <TScott-Johnson@xxxxxxxxxxxxxxxxxxx>
- To: "Formula help (E-mail)" <mso@xxxxxxxxxxxxx>
- Date: Tue, 17 Aug 2004 11:40:53 -0500
Is there a macro that can be ran to look in Column B, if there is today's
date (There could be multiple dates in the same cell separated by a comma)
look in the same row in column A to grab the persons name, and look in the
same row in column C to see what Document it is.
Then grab the worksheet page named "reminder letter" Fill in A4 with the
persons name that came from the last worksheet, then in D12 put in the
Document that was grabbed from Column C in the previous document.
Then email this reminder letter to the person who's name was now on the
letter that came fro Column A in the beginning of this information.
Thank you,
T
*************************************************************
You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or
MicrosoftOffice@xxxxxxxxxxxxxxxx
To send mail to the group, simply address it to mso@xxxxxxxxxxxxx
To Unsubscribe from this group, send an email to
mso-request@xxxxxxxxxxxxx with the word "unsubscribe" (without the quotes) in
the subject line.
Or, visit the group's homepage and use the dropdown menu. This will also allow
you to change your email settings to digest or vacation (no mail).
//www.freelists.org/webpage/mso
To be able to use the files section for sharing files with the group, send a
request to mso-moderators@xxxxxxxxxxxxx and you will be sent an invitation with
instructions. Once you are a member of the files group, you can go here to
upload/download files:
http://www.smartgroups.com/vault/msofiles
*************************************************************
Other related posts:
