email

I am using Office 365, and am storing Excel files in the shared OneDrive. I would like Excel to send automated emails, either based on a dynamic schedule (e.g. storing a list of dates in one of the sheets), or being triggered by some data in one of the sheets that gets updated dynamically based...

Hi Can`t understand why the FSOFile is not working it say`s wrong number of arguments error 450? Sub Send_Email(EmailTo As String, EmailCC As String, EmailBCC As String, EmailSubject As String, EmailBody As String, Optional EmailAttachement As String) Dim EmailApp As Object Dim...

I am using Office 365 / Microsoft Forms to collect information from users within my organization (i.e. sign in is required to fill up the form). Let's say the goal is quality control, and a bunch of widgets are assigned to colleagues to test and rate. A specific widget (identified by...

Hello, I am attempting to copy part of my excel worksheet as a table to an email. I have a for loop that loops through every row, with "rw" being the variable used for that current row. When I use my code, it is only copying column G and I am unsure why. Help would be appreciated 'Set the...

Sub COOutlookReminder() Dim OutApp As Object Dim OutMail As Object Dim strbody As String Dim myRequiredAttendee As Variant Dim Address As Variant Set OutApp = CreateObject("Outlook.Application") Set OutMail =...

i have a list of missing and file names hyperlinks I want to create a button that, when clicked, reads the entire column and if it finds "missing," will collect those rows range and then will go to column A and read the first 2 letters and, based on that, will send an email to the...

Hi all, I'm developing an excel template for my team to use to write up purchase orders and send a receipt to our client, and send our purchase orders to our vendors (distribution). I need help writing a macro that: 1) Saves the file in a specified location 2) Uses that file save location...

Hi guys, I have an excel file with a table, where I have clients and providers emails in column C. I have the subject in cell G4 And I have the body of the email in cell G5. I have a code written, but, it's not working as expected. I was trying to loop through column C and past the emails to...

Hi All I am working on a macro for an Email that will send some request to recipients. We are scrubbing the data on the responses so need them to respond in a certain way. I am trying to get the templates to auto-populate in the return email. I currently have the below coded up which is giving...

i have a problem with the code that i have, when it emails the workbook it wants to update the cell information, regardless of what you click update or dont update it changes the cell values to VALUE. withing the cells is a hard link to the workbook ... c:\xcl\Test.xlsm is there a way in the...

Hello, So, with help of kind people here I was able to make most of my project work, but have hit the hopefully last bump. Basically, I have a worksheet that based on condition decides whether the issue should go after Quality, Logistics or Finances, and then generates an email to be just sent...

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...

Hello, first post. Will appreciate any help - even just a pointer to the correct place to look. I'm struggling to word this requirement but here goes: I have a data table in excel (a proper table). Each record contains a student and several other fields of use. It also details the teacher, and...

Hello, my first post. I'm looking for a solution with my Excel VBA problem. Hopefully someone is able to help. I'm looking for a solution to send multiple emails with outlook to different mailadresses with different rows from my excel file. Employee name Email address Info 1 Info 2 Info 3...

Hi All , I would like to request an advice how to send multiple group email based on a cell content. Currently i have a table that contain , name , country , email , cc , subject. The current existing macro that i have is able to send an email individually within the table. I am testing out and...

Good evening, I'm very inexperienced with VBA, but would like to be able to have Excel draft and send an email based on options selected from a dropdown. The subject of the email along with the body of the text also need to have values from cells inserted. For example: "Yes" selected from...

Below code works, except that instead of a Signature that I have designated as default in Outlook to be added to all my emails, this code picks another signature. - How do I fix it for it to pick a Signature that I have designated as default in Outlook to be added to all my emails? Playing...

Hi, I'm totally new to Macro and I would like to know if it is possible to save the email in the Outbox of the Shared Mailbox. I understand ".Save" will save it in drafts, but it had to be saved in the shared mailbox not in my personal email. For some context, I need to create multiple emails...

Hi All, I am looking for a code that will help me copy a workbook and fill it with information from another workbook. i already wrote a code that creates a copy, now i need a code that it will take information from the source workbook put them into the workbook i just copied, i hope i have...

I am working on contacts sheet which I need to get the name from email. Multiple cases I have to faced and with the help of below post link, I formed the sheet below. Extract name and company from email address Case 1: The mail id may contain separators like dot, dash and under-score Case 2...