I have a macro which sends an excel file to certain recipients via outlook. I have embedded the voting buttons in the same macro. However, when I respond to the voting buttons, I am unable to add the sender and another group. The current macro .readrecipients, enables me to send it to the sender. I would like to add another group id to the same.
View 1 Replies
My Macro sends a PDF to a "To:" recipient and a "CC:" recipient. Both email addresses are referenced from cells. Here are the first four lines of the code:
With OutMail
.SentOnBehalfOfName = "myaddress@mycompanyname.com"
.to = Sheets("Sheet1").Range("N8").Value
.CC = Sheets("Sheet1").Range("T8").Value
The code works great right now. However.......
I've added another email address to Sheet1. The address is in U8. I need it to be the SECOND CC. I could BCC it easily, but that is not an option.
Code I would add behind .CC = Sheets("Sheet1").Range("T8").Value to make it also CC the email address in U8?
Am trying for a code which will send mail to recipients mentioned in column A [to] Coulmn B [CC] & formatted range should be pasted as body of email lets say C:F. Each time formatted header should remain same is it will contain column heading. I have a code which sends mail to specified recipients mentioned in code .
Code:
Sub Send_Formatted_Range_Data() Dim oWorkSpace As Object, oUIDoc As Object Dim rnBody As Range Dim lnRetVal As Long Dim WB6 As Workbook Set WB6 = Application.Workbooks.Open("C:TESTDaily_BKG.XLS") Const stTo As String =
[Code]....
my message box reply.
In cell e14 I have the following formula =IF(D14
I am currently trying to automate a receipt system. I have successfully managed to create an email based on calculated Excel data. The email is created using the following routine.
callref="12345"
strbody = "The main text of the email"
Set OutApp = CreateObject("Outlook.Application")
OutApp.Session.Logon
Set OutMail = OutApp.CreateItem(0)
On Error Resume Next
With OutMail
.To = "John Smith"
.BCC = ""
.Subject = "Test email receipt - " & callref
.Body = strbody
.Display 'or .Send - still developing!!!
End With
On Error GoTo 0
Set OutMail = Nothing
Set OutApp = Nothing
My problem is that there will be several people using this system so I would like to include a reply address which is different from the sender. Alternatively, I would like to send the email from a different account (but I have to assume that the users will have their own email accounts open).
I’m currently writing a code, which will enable me to run a code, which will reply to a selected email with standard text in the cc, subject, body, and so on.
The code that I managed to write creates a new email message, instead I want the code to select "reply to all" to the email that I’ve selected, and then fill in the cc, subject, body, and so on.
Sub test()
Dim msg As Outlook.MailItem
Set msg = Application.CreateItem(olMailItem)
msg.Display
msg.CC = "test@hotmail.com"
msg.Subject = "testing!"
msg.Body = "hello all" & vbNewLine & vbNewLine & "We agree to your call..."
End Sub
I am using PrimoPDF, as suggested elsewhere in the forum, to attach a PDF to an E:Mail and send it automatically, it works a treat ... however, I do have to manually intervene to click on the OK button & then again to click on YES when the filename is duplicate. I would like to automate these actions and am looking for a way to do it. It looked like the SendKeys command was perfect, but I'm not 100% sure how to do it. The PrimoPDF window is open, named as "PrimoPDF", but is not my active window, so I have put PrimoPDF.SendKeys "{Enter}"
... into the program but I am getting the error message "Run Time Error '424': Object required". Is this something to do with my code ? I am guessing that the program isn't recognising that PrimoPDF is an open & inactive window, so am I missing a prefix here or is it something more serious, like having to add a new Component or Additional Controls ?
get the code for sending multiple emails as per the spreadsheet list. Assume the spreadsheet has 100 line items and each columns specifies the name of the person, value, recipient email address ("To" and "CC") and sender name.
And the Body of text is :
Hi "Name of the person" Please find the value of "Value" to be paid for the moth of xxx and kindly let me know for further clarification.
Is there any way someone can put the option of "SOLVED" on the post reply when you are the orginal poster.
Now you have to reply to the post then go back into your orginal post to mark it solved. they would be more willing to mark the thread solved. I have noticed many people get an answer and never respond or mark solved.
I'm not sure if this is a macro problem or an Outlook problem. I'm using the routine below to email a group of recipients through Outlook (not Outlook Express). The routine works fine for one recipient, but doesn't seem to work for multiples. I searched online, and found a solution of putting the email addresses like this:
"Joe@email.com;Bob@email.com;Mary@email.com"
That didn't work, so I tried it below with AND, which also doesn't work. What happens in both examples is that Outlook tells me something else is sending a message, and do I want to allow it (same as message when I send to a single recipient). I say "yes", it appears to go through, but nothing is sent from my outbox. Here's the
I have obtained the following code which works great apart from the fact that I want to just send one email to all addressees instead of multiple emails.
View 11 Replies View RelatedI feel like I almost have the Excel button I need (thanks to an exhaustive forum search), but I have 2 problems that I need help to correct. First, the code works fine if I have one email address in my Email column, but If I add a second or third email in my column, the code sends the mail, but bounces back because of an Invalid Internet address specified error. The response looks to me like it is taking the first address and appending to the second email recipient. An example would be <example@example.com,example>@example.com. Here is the code I am using:
View 3 Replies View RelatedI am trying to set my cod up so I can email my excel sheet to multiple people. I tried using a ";" to separate the email addresses (as shown below) but that doesn't seem to work.
With ActiveWorkbook    .SendMail Recipients:="bubba@gmail.com;bubba2@gmail.com", Subject:=s    .Message = m    .Close SaveChanges:=False    End With
I found the following macro after much digging and got it to work for me, but I'd like to go one better. Currently it sends a simple breakdown of orders that need to be placed. The data lies in a sheet called "Orders" where column A is the vendor name and column B is the order total.
This data is pulled from numerous other sheets, one for each vendor. What would be awesome is if I could send each vendor an email consisting of:
1. Item Number - Column C
2. Item Description - Column D
3. My Cost - Column F
4. Quantity to Order - Column J
5. Order Total - Column K
The complications I've thought of so far:
1. Each sheet is an inventory for the items we have from that vendor. It could be just a few items, or it could be two hundred.
2. There is one row per item, but not every item will have need to be ordered. I don't want an item to be included in the email unless there is an order quantity in column J associated with it.
3. Each sheet should be emailed to a different address which I'll put in A1 for that sheet.
I'm thinking I should do this under each sheet so I can just hit a button on that vendor's sheet and send each order independently.
Code:
Sub LNotesEmailPartsOrders()
Dim NSession As Object
Dim NDatabase As Object
Dim NUIWorkSpace As Object
Dim NDoc As Object
Dim NUIdoc As Object
[Code]....
I have a macro currently using the activeworkbook.sendmail command to send out an email using LOTUS NOTES with the workbook as an attachment. Unfortunately, the code appears to only support putting recipients in the TO field. I need to be able to also add additional recipients under the CC field.
View 1 Replies View RelatedI know there are plenty of examples on how to do this at a basic level but I am looking at making it a bit more custom.
I would like to put some variables on a sheet in a workbook and use those to drive the behavior of the code.
EG I would like to specify the save-as-pdf path (eg c:users.etc), the email addresses to be emailed TO (specify a range eg A1:A14 where each cell has a different email addy in it), like wise for CC and then BCC (new ranges), also be able to specify subject of email (EG Cell F1.value is email subject).
I have an excel sheet with 25,000+ emails in column A with hyperlinked emails addresses, Column B has different Subject lines based on the category the clients belongs to but on the same sheet, Column C has the following hyperlink :
=HYPERLINK("mailto:"&A2&"?subject="&B2,"Email")
To create a hyperlink of the email address with the desired subject line.
macros that i could use to open about 25/50 outlook message with the email ids in column A of the sheet and the subject lines in column B.
I don't want the messages to be sent automatically but i want to have the option to change the body of the email if necessary.
I need a code to convert different excel files into pdf and send to different recipients.
View 3 Replies View RelatedAuto generating an e-mail that will consolidate duplicate rows for 'column a' in my attachment. The key here isn't necessarily deleting the rows... What i really need is vba code that will enumerate through the table and auto generate an e-mail for each individual. For each individual, i need the code to generate a table in the body of the e-mail & attach the activity for that recipient and the date. The trip up here is when a recipient has two activities associated to their name, and their name shows up multiple times in the data set.
I need the code to
a) identify the duplicate recipient,
b) send out 1 email for that person, and
c) attach each activitiy/date (2 or more) to a table.
Automate the Consolidation of Duplicate Recipients to 1 Email (2).xlsm
I been trying to create stuff that will make my work life real easy. I need creating a program that will send an email to different recipients. I created a spreadsheet the contains different information. When a persons name is selected on Column D, excel/outlook will generate an email to that person containing the info on Column A to D.
And then as soon as the work is processed and column G is filled, outlook will generate an email back to who created the requests column A.
I am using the following code to try and send a workbook via attachment to multiple email recipients however it will not work. If I only include one recipient then the code runs fine however it crashes when there is more than one.
View 8 Replies View RelatedHere is my code below for a program that opens a user interface, lists all the names of tabs in the spreadsheet in a list box. By selecting an item (or sheet name) in the list box then clicking "email" a specific area of that selected sheet is sent to an email address located on the sheet.
What I would like to have happen is with the click of a button email each sheet to the specified email address. So if there were 100 sheets rather than clicking on each name then clicking email, have one button to email the each individual sheet to the associated email address. I am guessing something like a "For" loop would be required but am not quite sure how to implement.
Code:
Private Sub CommandButton2_Click()
ActiveWorkbook.Close
End Sub
Private Sub ListBox1_Click()
'this will set the label caption depending on which sheet is selected in the list box
Label1.Caption = Sheets(ListBox1.Value).Range("b2").Value
[Code] ..........
I have been trying to write a couple of macros;
1) save file as pdf, to be saved as filename=(cell in A1 & todays date (format yyyy-mm-dd)) and overwrite any existing file of the same name.
2) Email the pdf to a set of recipients round in Range "A2:A3", and subject = (cell in A1 & todays date (format yyyy-mm-dd))
I have this code below to send a workbook as an attachment to different recipients.
The macro finds the recipents by going through a list. The problem I am having is when it moves through the second loop and enters the line which is starred in the coding below.
Run-time error '-2147221238(8004010a)':
The Item has been moved or deleted.
Sub Mail_Workbook_1()
Dim OutApp As Object
Dim OutMail As Object
Set OutApp = CreateObject("Outlook.Application")
Set OutMail = OutApp.CreateItem(0)
On Error Resume Next
[code].....
I'm trying to create a macro the saves a report and then opens an email dialogue box populating the recipients from a list. I have the following code so far but the receivers are constant.
[Code] .....
I have attached a simplified example of the list. The list is always sorted by time and date. Not including headers, the list can be from 1 to an unspecified number of users long and users may repeat throughout the list any number of times.
The user name always appears as their email address prefix and the email address will always end in "@example.com".
I am aware that a loop could perform this task but do not know how to employ it in this case as it must not repeat recipients and will also need to populate the EmTo line. Possibly a second loop for this?
Attached File : Report Test.xlsx
I have searched high and low on the forum and can not seem to find a solution to my problem. Here is my problem (besides being new to Lotus Notes): I need a button on my excel worksheet that gets information from Column H in the attached spreadsheet and puts all the emails in the To: (could be >than 100 email addresses) Field in Lotus Notes. I would like to have the subject read "New Email from Your Basin Coordinator" and have the CC list come from a second worksheet (CC).
View 4 Replies View RelatedMy vb code works well for sending worksheets to multiple recipients (about 400 rows) IF I have only one email address in a cell, however, I have some rows that have more than one email address (eg. bob@hotmail.com, dan@gmail.com). I've spent hours researching a clean way to do this and I think I need to be able to extract each of them and assign them to a variable to use in an array???
I'm using Lotus Notes 6.5 and Excel 2003.
'Here is where I get the email address to put in the mailAddress variable
Workbooks("GSA Mileage Report.xls").Activate
mailAddress = ""
On Error Resume Next
mailAddress = Application.WorksheetFunction. _
VLookup(EmailAddrSheet.Cells(RowNum, 1).Value, _
Worksheets("MailInfo").Range("A1:B" & _
Worksheets("MailInfo").Rows.Count), 2, False)
On Error GoTo 0
My excel sheet keeps a list of Email addresses on column B (with duplicate email addresses), and their particulars from column C (Item price, purchase date, etc) onwards.
I need the vba to email multiple recipients (those with the "notification" field marked as yes) with their purchasing details in it. It should also prevent multiple emails to the same email address.
PS.Using Excel/Outlook 2010
I would like to generate a blank email with a list of recipients (no more than 40) in the 'To' field. I would like to do this in a single click on a cell with the text 'newsletter group' in it (cell B17). The recipients email addresses are in the format of one complete email address per cell in a column starting at C17 (C17, C18, C19, etc...). I thought I had found a way to do this (using the hyperlink function I think, but can't quite remember)but it turned out you could only string together about 8 email address before the function stopped working.
Also just to be clear, I don't want to send the workbook to the recipients.
I'm trying to email multiple worksheets from a list to multiple recipients in a list, but in one file per person. In a sheet called "Email list", for example, I have a list of 50 worksheet names (e.g. one for each cost centre) in column A (with a heading in cell A1, if that's OK, so the list starts in A2) and in columns B-F up to 5 recipients for each worksheet (e.g. 3 recipients might be 2 supervisors and their manager).
Also, each manager and supervisor might also receive several sheets.
Although columns B-F are presently free-format (they can be anyone's email address, regardless of whether they're a supervisor or manager), it might be easier to split these columns so B,C,D are supervisors emails and E,F are managers, if that makes it any easier creating the collated file of worksheets..?
Unfortunately the recipients might change occasionally so they can not be hard keyed into the macro itself (which would be much easier), but need to be in a table so it's easier for the user to update and maintain - in the past, I've managed to hard key the requirement into a macro which I've maintained (by recording and editing the macro), but I don't know the VB to figure this new request.
Ideally, I am trying to create a macro that can collate the various worksheets each person will receive and send the selected sheets in one file to that recipient, rather than multiple files within one email and/or multiple emails.
