send

Hi all, I have a form that staff complete. Cells A1:B6 contains information. I need VBA writing to complete the following: Send to designated email address Subject line to be B1 and B2 (example "Mr Smith 12 May 2019") Copy information from A1:B6 into the body of the email The user should...

Hello, I have poked around and haven't found this particular answer. I want to create a spreadsheet that has pre-filled message that is in lets say cell A3 and I want it to send that IM/Message to a user that would be specified in cell B3. B3 would be a lookup field from another sheet in the...

Hi this is my first thread in the forum I am trying to build an excel sheet to track reports the columns will be Date report requested//who need to make the report(reporter)// reporter email// send email for the reporter in the send email only three values are there Send email1 "send email...

Hi Everyone, I need suggestions that can we send mails from different accounts were i would be having usernames and passwords in an excel sheet, from those username and password it should login to outlook and send a mail(were all my mail details would also be in excel sheet itself) Regards...

I am trying to write a macro that will print every sheet in the workbook, except for a short list (START, Main Data, Master Blank for ERC, P1 Figure 2-2, P2 Figure 2-2, P3 Figure 2-2, P4 Figure 2-2, P5 Figure 2-2, P6 Figure 2-2, P7 Figure 2-2, and P8 Figure 2-2). The remaining sheets are all...

Hi Everyone, I been banging my head over 2 days trying to figure out how to forecast the amount of sensors. The data I have has column B (Locations) But this location doubles up based on the different branch it has. So some location can have up to 10 entries. from C to AC are dates that each...

Been trying to put together a macro that has the ability to send three emails to different addresses. The kicker is I want each email to take a picture of a range in the sheet and add it to the body of the email. I have tried a bunch of ways but continue to run into errors. Any help would be great.

Hi everyone, I'm at a bit of a loss with this one as the code I'm using I've used before without issue. My goal is to have Excel move a worksheet to a new workbook, save that file and send it and then kill the file. All the code is working apart from the code to send an email, when I've took...

Hey all, I would like to send an email from my listbox when i double click a name on it. Situation: Listbox named lstSearchResults Data that is displayed in it: Fullname, Department, Gender, Phone, Email So when i double click on a name in the listbox i would like to be able to send a email...

I have an Excel macro that will loop thru a list of ID's and send each one an email using Outlook. Everything works fine. The problem is that there is sensitive data in the emails. In my company when sending sensitive data in emails you must "Send Secure" using the Outlook plugin "Voltage". A...

>I am trying to send a pdf file from my hard drive >to a website that parses the pdf file into and excel file >and will get a <documentid> back as a response so later i can pick the >the corresponding CURL to send the pdf file > >CURL -u <secret_api_key> \ > -F...

Hi Guys, Is there a way to do the following: Copy columns A,C, E,Y, and D from 'Offsited Data' tab to 'Send CSI' tab and paste as paste values only in that order. So when pasted into the Send CSI tab column A to column A, C to B, E to C, Y to D, and D to E However, only copy the data...

Please could someone give me an idea if this is possible? If one of the cells in a table column is greater than 25% I want excel to send me an email. so something along the lines of: If (cell in net % column) > 25% then (send me an email) Although its not essential, it would make sense to...

I'm using this to create an invite and save it to my Outlook Calendar; Item.RequiredAttendees = "emailaddressofrecipienthere" Item.Recipients.Add "emailaddressofrecipienthere" Item.Save Item.Send It creates the item and saves it to my calendar no problem, it also has the email of the required...

Hello All, I have a small problem but I have no idea how to solve this, so I want to send a few emails to one person, just not one by one like in the code, but as package or something. For example: Mail to Mr.A where's assigned a few positions should be send in one mail. In mailbody will...

HI All, good morning, i have this code below which works but at the moment it sends the email from the cells in active sheet, and i want it to send the emails from my range in sheet 2 for example the .To i want to send from sheet 2 and B1, and at the moment i have named my range to screenshot...

Hi, I have an excel sheet which having 60 rows (aprrox. which will change every time) and 10 column of data In Column 11 I have stored Location (i.e. "Class A", "Class B", "Class C" etc) For example : Suppose Column 11 having 4 Categories then I want to send 4 emails, after...

Hello, I am looking for a way to get excel to send an automated email based on whether a certain criteria has been met. IF C12 = Completed THEN send email to "Email Address", containing text "Text body" to "recipeint email" Any help would be greta if it is possible, i think it has to be done...

Hi, Good Day guys! I need help on the code for sending an email (item.display instead of item.send). I want to have the TO CC and Subject ("Portfolio Dashboard Red and Yellow Report" + a prior specific date included (ex. Portfolio Dashboard Red and Yellow Report 27-2-2019) reflected as well...

I want to do as the title states. Print a certain range as pdf and send as attachment with a choice of a body. Can someone help me ? Thanks YM