subject

Hi, I'm using Ron Debruin's AutoEmail Macro I've been using it for a while with a lot of success, and now I'm migrating it to another task. It works perfectly, but I want one additional piece to make my life easier. In the subject of the email, I want the value from Columns I. Now I know...

Hi, I receive 20 to 25 emails a day from a common mail box daily to my Outlook 2016. I will then move those emails to a personal folder named "Daily email1" & "Daily email 2" based on email subject. I want this to be automated. Whenever I get those emails I want a button to run a code which...

Hi Good morning, please can you help me i have a macro to send an email and for the subject i want to add the text in the textbox2 into the subject heading i have done this in the code below but get an error please can you help? With NewMail .Subject = "Late Outage request - " &...

Hello, Last time I had somewhat same query and helpful tips from this forum, so I am here again, This time bit complex (at least to me). Here is the file with required format: https://drive.google.com/open?id=1jSG-azrx4r_zobaLUZwFijd9Rm8qcbB9 there are total 28 subjects a student can either...

Hello, I need an EXCEL VBA script which will perform the following operations: 1. Open my Outlook 2. Read mail with a particular subject line (let's say ' TEST MAIL') 3. Download the attachement from that mail to Desktop location. Please help me with the script. Thanks,

Hello! im just newbie in excel my question is what formula do I need to get just subjects of all Basic and Common type. My sample dataset; <tbody> Type Subject Basic Subject 1 Basic Subject 3 Common Subject 2 Core Subject 1 Common Subject 3 Core Subject 1 </tbody>...

Hi All, I'm in way over my head, but thought it'd be cool if this is something that can be done. I'd like to have an "Email" Button on every row that will use the data in the columns before it and put that text into the subject line. If my cell columns looked like this: 12345 Fake Street...

Hello - I am creating a macro to export an HTML table embedded in a Outlook email to Excel. The exporting piece is fine, however I am having troubles when saving. I would like to save the new file in a specific folder and the name should be the subject of the email. I am having issues with the...

Can't get the formula right. I have two tabs in a spreadsheet with many rows and columns. I need to pull the need contrac t a nd comments from Tab 2 to the corresponding address in tab 1 (which has a bunch of other info in it) Trying to use index match (don't want to use vlookup- long story)...

Hi Everyone, I'm stuck and was wondering if anyone can help. I have the students name in Column A. In Columns B, C & D is the subject choice. The student will only have one subject choice in columns B, C or D. In column "E" I want to record the subject picked. Example: A...

I have a macro enabled workbook that is used to manage room(3) allocations. I would now like to upload to a google calendar. I understand that goggle calendar requires a .csv file format. The main worksheet, Year 2019, is made up of many rows for the complete year (>2500) e.g. 01Jan19 to...

Hello friends, I'm trying figure out how to place in the subject, of an email generated through Excel, just what is in column B, last row. I'm having issues with that. Here is my code below, well not all of it... but I believe you should be able to give me what I need. The subject will be...

Hello, I've got a question regarding extracting multiple values. I'm well aware of vlookup and other frequently used functions but I need your advice for this one. Let's say there are teachers and we want to match their subjects they teach at school using pre-existing subject key codes...

Hello, I've got a question regarding extracting multiple values. I'm well aware of vlookup and other frequently used functions but I need your advice for this one. Let's say there are teachers and we want to match their subjects they teach at school using pre-existing subject key codes...

hello, I currently use :- Dim OutApp As Object Dim OutMail As Object Set OutApp = CreateObject("Outlook.Application") Set OutMail = OutApp.CreateItem(0) On Error Resume Next With OutMail .to = "" .CC = "" .BCC = "" .Subject = "This is...

Hi Guys Need your assistance in separating the words given in the subject line For eg : the subject line as below Returned Ticket Notification INC000000515843 Returned CI: SAP: Transport Equip Missing Information I want to separate word which comes after Returned CI till ":" or "-". In this...

Hi, I have the code below how can I modify it to get the email address and the subject with payment amount from the cell and add signature. Sub Send_Range() ' Select the range of cells on the active worksheet. ActiveSheet.Range("A1:D15").Select ' Show the envelope on the...

Hi I am new to power queries. I am a teacher and try to accumulate all the score for the whole school. I have 15 subjects and each subject have 15 classes to pull the score in. My goal is to be able to receive all the subject scores for each classes(15 sheets in 1 excel). Something like this...

Hi guys i would like to find command like Instr InStr(1, Subject, SoughtWord, vbTextCompare) > 0 This is for subject lines but i want to copy and 1 command line to search for Email sender can you please help me? Appreciate any help!

Hello, i have the code below where i am tring to add the date into my subject, i have added the date picker in Excel called DtPicker1, but when i have added into the code below it doesnt work and i get an error can you help me please? aEmail.Subject = "Saturday - " & Range("B1").Value & " " &...