recipient

Hello, I am looking for some Code to put in Outlook so that I am able to select a few calendar items (or all) and add a new recipient (Which is a room). I think I then need to send the calendar invite on but only to new recipients (the new room). No historic instances need to be changed. The...

Hello, I am looking for some Code to put in Outlook so that I am able to select a few calendar items (or all) and add a new recipient (Which is a room). I think I then need to send the calendar invite on but only to new recipients (the new room). No historic instances need to be changed. The...

What VBA would be needed to insert into a macro to notify an email recipient that a file has been modified?

Hello, I have a dataset where I want to locate the person with a value in a particular row. The table below is on range A1:E5 <tbody> Boyle Hayle Coyle Neli Coile -175 0 178 139 -142 -175 0 178 139 -142 -175 0 178 139 -142 -175 0 178 139 -142 </tbody> I want to search for the...

Hello, I would like to know how to develop an automated email response based on user response. This is what I would like to develop: Using Outlook 2007 a template is created with a mail list group and two buttons that allow the recipient to either Approve or Deny the specific event. Once the...

Hello, I have a word doc that I have set up as a mail merge from my excel file. I would like to be able to select a cell (a single recipient) in excel and have a user click a button ("Print") and have the paperwork print out for the single recipient that is selected. Is there a way to do this...

Hi, I wrote a VBA Code to send a mail to the recipient based on a criterion. My next step is a bit complex and I am not sure how to proceed. Problem: I have a criterion, passing which, a mail will be sent to a recipient. But there shall be several instances where the criterion is TRUE and...

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

I have written a macro that filters an excel sheet and emails the results to an email recipient - it uses "Send sheet" rather then send as an attachment. The problem I'm having is that when the email recipient replies to me, the sheet appears unfiltered and is causing confusion (I am sending...

Hello, I need to send out a standardized email, but I need to change a few fields within the body of the email to reflect names specific to the recipient. It's pretty simple, but I can't find anything specific to this case. Example: Hello _______, Here are your login credentials: Username...

I set up a VBA to automatically email a sheet of a document to a recipient and a separate VBA to send the sheet back to me. I can’t get the Microsoft Offics signature line in excel to go with the sheet when the VBA is used. And once the signature is signed by the recipient, the 2nd VBA quits...

I'm using a command button to automatically email a document. I have the recipient (srecipient), subject line (subject) and the body (sbody) text setup - I want to add additional recipient as a "CC". Any help on this would be appreciated.

Hello I am using code from the below link to send multiple sheets to email addresses in cell a1. http://www.rondebruin.nl/win/s1/outlook/amail5.htm I have hit a snag though. My sheets are made up of filtered pivots and I don’t want the recipient to be able to take the filter off. Could the...

I need the recipient cell to equal the value posted to cell I165 only if cell E10 on the worksheet titled "Candidate Selection" equals "C" ... otherwise the recipient cell is to remain blank

Hi :) I was wondering if someone could help me with a formula I am having a hard time coming up with: I have an excel sheet with various recipient addresses. The recipient name column, say column A, will look something similar to "Ship to business #1584" or "Ship to business #1224" or "Jane...

Good evening everyone, I wonder if there are some VBA people that like a challenge! I am trying to find a way to copy a range, save it as a .pdf, open outlook, send email to recipient and message, copy ranged contents place onto another sheet as a list (ie next row down from previous entries)...

Need a conditional formula to address the following issue: If cell E10 on a worksheet identified as “Candidate Selection” = “C” and cell G6 on that same worksheet is not blank, post the value “Y” to the recipient cell….if these conditions are not met, the recipient cell is to remain blank...

I would greatly appreciate help with formulas to address the following two conditions: 1). The recipient cell is to equal the value posted to cell F82if cell F83 = “CRITICAL” and cell M83 = “X” …..if these conditions are not metthe recipient cell is to remain blank. 2). Therecipient cell is to...

Hi Is it possible to create a macro to email from Excel which runs through a vertical list in excel and sends the email (and attachment) to each recipient one at a time....there is a list of 250 people so I need to send the same file to 250 recipients without each recipient seeing the other...

I want the recipient cell (I6) to equal the following statement: "Cable Median Barrier Repair" if the value posted to cell E10 on a worksheet identified as CANDIDATE SELECTION is "C". If however, the value posted to cell E10 is "R", then the recipient cell (I6) is to reflect the following...