How JustAnswer Works:

  • Ask an Expert
    Experts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional Answer
    Via email, text message, or notification as you wait on our site.
    Ask follow up questions if you need to.
  • 100% Satisfaction Guarantee
    Rate the answer you receive.

Ask Richard Your Own Question

Richard
Richard, Software Specialist
Category: Microsoft Office
Satisfied Customers: 31329
Experience:  Over 15 year experience resolving Microsoft Office Issues
32989067
Type Your Microsoft Office Question Here...
Richard is online now
A new question is answered every 9 seconds

hi, i need the excel sheet to send an automatic reminder

This answer was rated:

hi,

i need the excel sheet to send an automatic reminder to outlook based on the date mentioned on the excel

thank you
Thank you for your question, my name is Richard.

You mean to send an email to Outlook? With a Calendar Item?

On Outlook on the same computer?

Thanks
Customer: replied 3 years ago.


hello,


 


yes i have an excel sheet with due dates, what i need is that on the due date an email will be sent automatically to the same person

ok, you need to do VBA code to do this, are you able to?

Or you want me to do it?

If me, I need the file then


- Click the following link: http://www.wikisend.com
- Upload the file to that website
- Once it is uploaded, the resulting page will display a "File ID" number.
- Please, give me that "File ID Number"
Customer: replied 3 years ago.


926486 i want to link column E to outlook

Thanks

I have modified it. There is a button your press and it will create an email for each overdue. You still need to send in Outlook.

Unless you have an IIS server at your location, this is the only method.

I added a column for the email addresses, so update these so it can pre-fill it in Outlook.

You can download the file with the ID 323212

Let me know if you have any difficulties please

Thank you
Customer: replied 3 years ago.


hello


 


i have put the email in the email column and clicked run but it didn't work

It may have been a difference with the Date Format

Can you use this version and Let me know if you have any difficulties please

486450

Thanks

Customer: replied 3 years ago.

hello


i have put the email address in one row and clicked run


1- several emails were opened


2- the email opened has no email address which i mentioned in the email column


also i need to change the subject in the email how to do it


 


thank you

I made an additional column for the Subject (so you can enter it)

Also the To Address should now work

File ID: 966674

Customer: replied 3 years ago.


hello


 


still several email are opened at the same time i just need the email to be created only when the date is due also if possible i need a column where i can write in the email not only in the subject


 


thank you

It only opens the emails that are Due.

It will open emails for rows where the Due Date equals today. this is what you want correct?

I can make the message part but need to know this first please.

Customer: replied 3 years ago.


hello,


 


yes this what i want

that's what I have done for you.

Which company is it picking up it should not?

Customer: replied 3 years ago.


hello


 


No it's not working :


 


1- several emails are opened with empty email addresses and subjects


2- i tried to change the email address on the same cell and click run many empty emails were opened and the old email address which i changes to a new one showed instead of the new one

ok, then it is not going to be possible to have it automated on your computer.

I have approached it differently. Download this file,

File ID: 743840

When you enter the data and click the button, it will make Links. Click on these to have them become emails

Let me know if you have any difficulties please

Richard and 2 other Microsoft Office Specialists are ready to help you
Customer: replied 3 years ago.

ok thank you now it worked

Your welcome.

The links are the best way forward Johnny and will stay working

If you have problems, or would like any additional information or assistance, please do not hesitate to let me know.

And if you can take a second to rate my service, that would be greatly appreciated.

Thank you