automatic email

Hello, First of all, I am still new to VBA and more complex excel coding, so I'm learning by doing, searching forums and tutorials, stitching together bits and pieces of code I need. However, I ran into a dead end and would need help. Basically, what I'm trying to do: I have a project to sort...

Hey guys, I am new here, and not an excel "expert" whatsoever, so I don't really have much knowledge of the code itself. I currently have a master file that is saved to our company's One Drive. This file contains 8 sheets in the workbook and at maximum goes from column A to column V. At the...

Hello experts, I am quite new to VBA. Currently, I am working on a project where I want to send an automatic email seven days before the due date notifying that the due date is approaching. I want to get the date and the respective email address from two different sheets. I searched for other...

The main purpose of the following code is to Send a reminder as an email if TODAY + 60 > Deadline meaning that i need to get a reminder 2 months ahead of an expiring fixed contract of a vessel and take the names of the vessels that make my formula TRUE as 'Send Reminder' and forward only the...

Hi All, Thanks in advance for any help you can provide. I have quite a large spreadsheet. I want to set up an auto email reminder (using outlook) so I can go back and check on the status of certain files I keep track of. I have a userform that fills out certain information and on this I have...

I have an excel workbook full of different spreadsheets that monitor different inventory items. I have written a VBA code that sends an email to the person responsible for an item along with its current inventory and ordering information at the click of a button to notify them in case they need...

I have a bunch of reminder mails to send everyday. I have researched MrExcel and all responses talk about VBA. I know nothing about VBA. All I have is an excel and Lotus Notes. Can anyone help me with the basics? Is there anyway to do this without coding?

I have this code in VBA which currently works perfectly fine but I want to add to it and cant seem to get my head around it. As it stands, when you press save on the workbook it automatically sends an email to the email address in the code stating the date and time the work book was updated...

I am new to coding and I am doing everything I can to learn all that I can but I need to get a code established ASAP for work and am looking for some help. I think it's pretty basic but like I said, it's all new to me so it could be complex. Anyway, I am trying to get an automatic e-mail sent...

Hey all, l’m new here and hope I can get some help with a macro. I have a workbook that tracks data from employees and what I need is an automatic email sent to HR when either of two columns (column AE and AF) reach a certain cell value. It will also need to send another email with any increases...

i have found this macro to complete a spreadsheet that i am working on but am missing the correct command to automatically send the email with no human intervention the enlarged .send at the end is where it fails everytime what is the correct command?: