auto email

Dear, I have an excel file that have an expiration date, and I would like that when the date is -15 days before expiring it send an email automatically based on some cells information to the outlook email once the system logged in. I have add a code but it is not sending auto email and I have to...

Hi, I'm pretty new to VBA. i have a pretty good idea of what needs to be done but unsure how to string it all together and need some assistance. I'm trying to create a VBA macro that will automatically use the data from a spreadsheet to pull data from the spreadsheet and send to corresponding...

I have writen this code but it is not pulling th info i need into the seperate worksheets?? Private Sub SEND() Application.DisplayAlerts = False Dim Issues_all_rows As Integer Dim Receipts_all_rows As Integer Dim Stock_all_rows As Integer Dim Stock_sup_rows As Integer...

Hello all, I believe long ago I found on this forum a very helpful VBA code for sending an automatic email from data that was contain in a table structure in excel. I would like to use the same characteristics (i.e: referencing data from certain rows and based off expiring dates) but I no...

Hello everyone i have a vba code to send email via outlook but the issue i don't know how to add signature to it, can signature can be predefined in the program or is it possible to extract signature from outlook using any command in vba code please help me out , below is my code , thanks in...

Hello i have to create a vba code to send email of the first row then next row then so on i have created a vba code but i have few issues the values in COLUMN A SHOULD GO TO THE "TO" FILED OF THE OUT LOOK and B C D E F G H should go to the body of the OUTLOOK please help me out and i will post...

Hello, I have an excel workbook that I am willing to privately share as well as the code i'm hung up on. Basically I would like it to scan the dates in column c and if it is within 30 or 90 days of Today then it will auto send an email to the email address in column b. I have been getting stuck...

So I have been compiling data on a sheet I have for work. Now I have all the data I need and have all the formulas I need to make it work except an auto email function to let customers know that they need to make contact and update their expiration dates. The date of expiration and their email...

Hi, I have successfully tested the following code that automatically sends emails with attachments, if required, to a list of email addresses within a spreadsheet, column A. Before I start using this with "live" data Is there a way of highlighting rejected/non valid email addresses back to the...

I need to have excel check sequel server every 10 minutes. I need to send an e-mail notification if a value changes 5 between the checks. The sequel server is no the issue or having excel automatically open in my background. I cannot figure out how to make it remember the first value between...

I have a spreadsheet where I want to require certain fields to be completed then I want to have that file auto emailed. I have learned that I do need to have the file saved before sending otherwise the data will not appear in the email, so with this I want to have the file temporarily saved...