Excel

Resolved · Low Priority · Version 2016

Wed 16 Jan 2019, 16:14 Delegate Alexandra said...

Alexandra has attended:
Excel Intermediate course

Excel

How to set email alerts for nearly due or over due dates on an excel spreadsheet

Thu 17 Jan 2019, 08:45 Trainer Jens said...

RE: Excel

Hi Alexandra,

Thank you for the forum question.

Almost everything is possible in Excel, but what you want is complicated. You will have to have knowledge of VBA coding and write the code. You will need knowledge of writing decision codes, loops, Outlook VBA and understand object variables.

I found an add-in by googling. I have no experience with the add-in so I cannot tell you, if it is any good.

https://ipushpull.zendesk.com/hc/en-us/articles/115003779429-Step-by-step-Sending-Email-Alerts-from-your-MS-Excel-spreadsheet

Kind regards

Jens Bonde
Microsoft Office Specialist Trainer

Tel: 0207 987 3777
STL - https://www.stl-training.co.uk
98%+ recommend us

London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector

Thu 17 Jan 2019, 09:05 Delegate Alexandra said...

RE: Excel

Thank you for coming back to me so promptly. I knew it was not going to be straightforward. Thank you for the add-in, I'll see how I get on.

Thanks again

Alex

Training courses

	98.7 % recommend us
	More live stats...

Training information:

Excel tip:

Using Alt in Save Dialog Box

When you are saving (or opening) a file, try these;
(Note the numbers are on the keyboard not the numeric keypad)
1. Go to previous folder Alt+1
2. Go up one folder level Alt+2
3. Search the Web Alt+3
4. Delete selected file Alt+4 or Delete
5. Create a new folder Alt+5
6. Cycle through all views Alt+6 repeatedly
7. Display the Tools menu Alt+7

View all Excel hints and tips