subject

Hi all, first time posting in the BI forum, regular in Excel. I am attempting to build a dashboard with regards to our work team email inbox and sent items. I have created flows that save data to various excel sheets. I have 2 tables in BI. Table1 is data from the inbox. From - Subject -...

Hi, How to apply the conditional formatting for blanks cells with multiple criteria of the following data. https://www.dropbox.com/s/bfumzp5zzwu77bo/CFCB.PNG?dl=0 <colgroup><col span="4"></colgroup><tbody> CODE A1 A2 A3 SUBJECT SUBJECT 010 SUBJECT 010 SUBJECT 009 EXAM 5 GRADE1...

Hi Gents, I'm struggling on the above subject guys. Any help! Many thanks.

Hi please can you help me i have a button which when clicked sends an email :), but in the subject line i want it to copy what it says in my dropdown box in userform8 the drop down box is called 'ComboBox1' i have tried the code below but it seems not too work, please can you help me? i am...

Hi i hope you can help, i am tring to add the data entered into 'ComboBox2' into my subject heading in an email, i have tried the below code but i get an error, i really hope you can help me? thanks for your time. aEmail.Subject = Range("ComboBox2").Value

Hi All. Am in trouble. I have a filtered data set of only Integers in an Excel sheet. Col. 1 is Date Col. 2 is Subject Names Col Y is COLUMN OF INTEREST - Its where you may find Subject Names with more than one Integers eg. 9.00, 246.00, 1765.00 etc under one Subject Name. I only need 9.00...

Assume below is a excel worksheet with consolidated emails from MS outlook(by export data function as .CSV) , I need help to develop VBA code to trigger action to forward email from ms outlook Inbox folder where below Subject = C2, then should get forward to assign=D2,similarly C3 then should...

I would like to open a new email by pressing a button on my spread sheet. With the name to the person I want to send it too and subject. If any one could help please. Thank you

hi I have a table of data with 6 columns columns B, D and F are the choice of subject columns for info only these list the subject names. In columns C E and G i want the user to be able to enter a Tick to select a subject from each column but only one so once a tick is entered into one cell...

I have the following code, but I am struggling to get the final part done. THe email body is blank and I cannot work out what I am doing wrong. Sub SendOutEmail() Dim rng As Range Dim rngAddress As String Dim OutApp As Object Dim OutMail As Object Dim PNGFile As String...

I'm trying to find a way to search my Inbox for a message with a specific subject and if it's found change the subject and move it. I've made progress and it works but only if I specify the exact subject - so does anyone know how I can search for part of the subject filed as below, (which does...

Hello! Currently, I have a set of raw data that has a time-stamp for each question, each session and for each individual. For example: <tbody> Subject Session Question Time 1 1a 1 08:59:22 2 1a 1 09:00:13 1 1a 2 09:01:58 2 1a 2 09:01:33 1 1b 1 08:33:24 2 1b 1 08:31:22 </tbody>...

Thanks for looking. I have some code for emailing that works very good but I have one change i would to make. I would like the subject to be Subject: Req activeworkbook.name This is a section of the code im needing to edit .CC = "" .BCC = "" .Subject =...

Hello All Hopefully this will be a nice easy one for someone, but I just can't seem to work around this one, I'm sure I must be missing something obvious. I've got a piece of script to download a file from Outlook based on the subject line which currently works fine, providing the subject line...

Hi Group, Greetings for the day ! Please find below my query : I have created a sub-folder by name "Request" on my outlook mailbox where I have run a rule based on certain specific words in the subject line. Now, all the mails in this particular mailbox have certain text in the mail body...

Another query for which I would really appreciate any help. I am trying to provide departments a breakdown on their subject and one of the sections is a list of students who are under performing and have behaviour issues. I have found a formula to do this but I am trying to automate the...

All, Hoping someone can help. I have a excel book with several sheets that get filled in and the aim is to have a button on the last sheet to send the completed form attached to an email. I've managed to get this bit sorted and a simple subject line with some generic text however I'd like to...

Can someone help me with this please, it's one area of VBA which I have never been able to truly understand no matter how hard I try; I have 3 Comboboxes on a Userform, named ComboES1, 2 and 3. I want a routine to run when the Comboboxes are changed to do other bits in the following...

Hi i have this code for subject line of email works fine but once i put the number format shows the word "false" in the subject line, here is the code: EmailSubject = "TNW a/c " & " " & ActiveSheet.Range("A3") & "," & " " & "Statement Of Account $ " & ActiveSheet.Range("I1").NumberFormat =...

Good afternnon Mr Excel's forum, I am trying to #1 Open the last email received containing a specific reference in the subject #2 Save it in a specific folder in windows (let's say my documents) #3 Store it in a subfolder in outlook( which is a shared mailbox, different from the defaultforlder...