send

I would like to send an email for each person in a table based on the confirmation column. Meaning if is True, that person will receive the email. Otherwise not. I would like also to choose to send to everyone (Confirmed as True) or to send individually. <tbody> Name Email Type Confirm John...

Hi all, i have been working on this project for week and couldn't find a way and i hope you can help me please. i have excel sheet where has equipment with number of running days and if the cell reach certain value, it should send email to the responsible employee. i have about 25 equipments...

Hi guys just wondering if someone can confirm something for me. I've got a workbook which requires users to edit data and once they've finished their edits they click a command button which runs a macro. In the macro I have ' ActiveWorkbook.SendMail' would this send a copy of the workbook with...

Is there a way to send keys inside of a batch script (.bat file) on Windows 10 to Excel 2016? For example, this link below provides an example on how to send keys in a batch script (.bat) to Word using the following commands: Link...

I love the "send email to recipient" command and it works great for a tool I have in place to share updated negotiated prices. As I need more people to be able to use the tool, I have to consider their "limitations." Is there a code someone can provide me that allows me to create a button on...

Existing Macro:- I have an existing macro with a send Email button on clicking it will send separate mails with single attachment to all the owner.present in the excel sheet. Requirement:- while clicking on send mail button it should first pick an owner i.e. mail recipient from coloum D of...

<tbody> <colgroup><col><col><col><col><col><col></colgroup><tbody> 30 Investors Rate Lender A Lender B Lender C Lender D Lender E 6.125 #N/A 105.801 #N/A #N/A #N/A 6.000 #N/A 105.192 0.000 105.782 105.382 5.875 0.000 104.883...

Hello World! I'm not sure if this is the right section to post this, but I'm needing some help. As of the beginning of July my company opted to ditch Microsoft Office (To cut expenses) and moved to Google. And that ruined a lot of my macros. I have no idea of how to script in google but I've...

I have a spreadsheet hat has multiple lines that have an identifier in column B. I'm wondering how I would go about building a macro to send the entire row while keeping the existing row to the second worksheet based off it's value. For example, send 0A on column B to 2nd worksheet as well as...

I am creating an Archive macro that when pressed will send a worksheet from one workbook to another. Currently the code will open the workbook and send the worksheet and then delete it from the original workbook. The problem I am having is saving the destination workbook after it has been...

I have a workbook that has several worksheets tracking data. I currently have the code to send 1 worksheet and a button located on that sheet. How do I tweak the code to send both sheets in one email? 'Copy the ActiveSheet to a new workbook ActiveSheet.Copy Set Destwb = ActiveWorkbook

I have a spreadsheet for work that gets populated with various issues. I have to notify each person who is in charge of resolving the issue, there are so many at this point I am running around all day. Is there a feature in excel or a way to send out an email to a person when their name is...

Hi everyone I am looking for a little help on a project i want to undertake i want to use excel to set up a kind of database whereas if i have got a customer and i need to send him an invoice on a certain day of the month i get alerted so i can then generate an invoice to send the customer or if...

I have created a macro to send emails using outllok. but in my organization there are some IC labelling add-ins there like “ highly restricted, restricted, internal and public. without selecting one of these option we cannot send emails. how can I add a code to select one of these option? please...

Automatically send mail our measure point is the "DATE" when it's in the place send the mail our mail is depends on the cells in the excel I will provide a picture to explain what I mean https://ibb.co/iK3bxK I think from the image now you understand what I mean Thanks.

Hi all, i need to create a formula as per the below where you have a store with customer orders in column A, what is in stock in B, what they have soon to arrive at store in C and D is how many they are short. Column F is what stock is in the warehouse, and waiting to be transferred but due to...

Hi all, been some time since I have had need of your excellent advice/help. I need to send out a questionare to approximately 50 people. Each one will contain their individual personal information that I need to get back from them if it needs to be updated. I would like the excel spreadsheet to...

I have a rather complex email being created in excel, currently it works fine but I want to skip the step where I have to click send... I want excel to generate the emai (code already works) and then rather than have to click the send button - i just want it to go. Reason? Well I am needing to...