Hi guys,
i'm not a good user of excel so i'm asking you to help me.
i have one file excel (called 7x24.xlsx), it contains a lot of name of the people that should travel and i have to send they an email with an advise.
everyday my colleague update it with new names (he put near the name an update date.. for example if today is 1/5/15 : one column (A1) with the name: Rossi Mario, one column (B1) with the start date of the travel :02/05/15 and another column (C1) that indicate the date of the insert into the file :01/05/2015).
When the file is updated, i'll check the new people inside the file and i send an email to all the travellers.
every week is like this for me:
on Monday I send an email to people who start the travel on Thursday of the same week (i copy all the travellers name from the excel file and i paste this name into Outlook)
on tuesday i send an email to people who start the travel on Friday of the same week
on wednesday i send an email to people who star the travel on saturday and sunday of the same week
on Thursday i send an email to people who start the travel on Monday e Tuesday of the nex week
on Friday i send an email to peolpe who start the traver on Wednesday of the next week.
Using this method i find an error.. (for example) if is tuesday and my collegue has just update the file with new Thursday travellers, i don't sent the email to them but only for friday travellers and doing like this all the new name for thursday are lost.
since I realized the error, I have to check every time all the latest send emails and check if other people have been included.
can you help with a new method? or a specific option of Outlook/Excel that helps me?
Thank to all for the support.
Andrea.
Bookmarks