Send email to specific name that meets weeknumber criteria

B

Birdy01962

New Member
Joined
Jun 27, 2016
Messages
26
Please help, I have been working on code that has a list of names in table. each name is assigned scheduled weeknumber throughout the year. I want to send an email reminder to a name when weeknumber matches current week. I also have a standin weeknumber where name 1 cannot meet schedule and someone within the group takes over, a different email reminder is sent to the standin name. If name does not have an assigned weeknumber move on to next name without sending email reminder. I have a number of worksheets with identical data which i wish to scan through at the same time. I have worked on code for quite a while but believe I'm on wrong track and this job can be approached in a different way, hence i have not attached existing code.
Team 1
BookersWeekly IndexStand ins
2024​
ABCDEFGHIJKLMNOPQRST
name1@btinternet.comName112161718313233344748495023
name2@btinternet.comName2345619212235363738515215
name3@duck.comName3789102324252639404142
name4@hotmail.comName4111213142728293043444546
 

Excel Facts

How to change case of text in Excel?
Use =UPPER() for upper case, =LOWER() for lower case, and =PROPER() for proper case. PROPER won't capitalize second c in Mccartney
You must log in or register to reply here.

Similar threads

N
  • Question Question
sending email from excel via outlook, send list
Replies
4
Views
278
Trebor76
T
T
  • Question Question
vba to send calendar appointments rather then emails
Replies
1
Views
692
Tej92
T
C
  • Question Question
Create code that sends emails and creates a log
Replies
1
Views
315
cokeoverpepsi123
C
C
  • Question Question
Send Email from Excel - Launch User's Default Email Client
Replies
3
Views
522
Micron
M
R
  • Question Question
Get other workbook names matching cell values from main workbook
Replies
0
Views
259
rcmistri
R

Forum statistics

Threads
1,224,828
Messages
6,181,213
Members
453,024
Latest member
Wingit77

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top