subject

Hi all! I currently have this setup in Excel: And the code is this: Option Explicit Private Const FilePath As String = "\\COMPANY.MSAD.COMPANY.NET\userdata\t543932\home\Documents\TESTfolder\" Sub send_email_complete() Dim OutApp As Object Dim OutMail As Object Dim i As Long Dim...

Dear all, (Please note that I am using the Outlook program in Windows). I currently have a setup that looks approximately like this (please ignore the snippet on the right side, it is purely to show what an email looks like in an outlook format): I was wondering if it would be possible to...

Hello everybody, I am currently following this youtube video: (specifically look at around 07:30-08:30) in order to create an email link in my excel file that people can click on, have a pre-determined email message written and then fill out the blanks and send it out. However, while I tried...

Would it be possible to have your help to create a macro that allows to send an email notification based on the assigned name on ComboBox3 where I can modify the subject and automatically attached a pdf file that it is previously created. The path of the pdf file changes depending on the entry...

Hi all, I've confused myself once again and can't figure this one out. I'm trying to figure out the macro to save file as a PDF in the Set Printing Area and attach the PDF file to new email template in outlook so that way the user can write who it's got to be emailed to. And if it's possible...

Hello! I'm looking to search a table like the the one below. In a separate sheet in the workbook, I'd like to have the "Subject" as multiple columns and list underneath it all of the titles that match the subject and have the language in english. I tried working a combination of index and match...

Hi Team, I want to extract outlook emails data in excel using VBA according to specific words in subject of email. The subject of emails keep on changing but some part of the subject remains same of all the emails. eg. My email Subject is "Prod - Work Daily Alert for user Steve Johnson...

Any help is appreciated. I am trying to run the following PS code within VBA and return the value for $email and $FASCN argument to an Excel worksheet. $myEDIPI = (whoami /upn).replace('@mil','') $comOBJS = @() $PIVCERT = gci Cert:\CurrentUser\My | ? {$_.Subject -like "*$($myEDIPI)*" -and...

Hello, I wonder if anyone can help me with a Macro issue. We have an Excel form with a Macro that automatically emails the workbook. The line of code that does this is ThisWorkbook.SendMail Range("Welcome!R3"), Range("Welcome!R6") Where R3 contains the email address to send the email and R6...

Hi All I want to import mails from my outlook inbox to excel sheet depending on subject line i.e. if and only if subject line contains text APPROVED or CLARIFICATION at the start of subject. Subject : APPROVED xyzz..... CLARIFICATION abc..... only this type of mail need to be...

I'm trying to help out a professor who is in charge of keeping track of teaching assignments. He's using a spreadsheet with a sheet that lists all courses and separate sheets depending on the subject. But sometimes he may forget to update the main sheet when a change is made to a particular...

Hi All, I have an unusual yet important question. My question is: I obtained the marks of about 150 students, in 4 different subjects. I have them in the list with 3 columns; first column is "Subject", 2nd is Student ID and 3rd is respective marks in the particular subject. Issue here is I...

Hi all, This is my first time asking question online for excel(mostly just google and have the answer) but i struggle to think of a good way to ask this question on google. Basically I am making a cell at E2(shown below) to show subject 1 OR A2 <tbody> A B C D E 1 subject 1 subject 2...

Hi, Currently have data set up in multiple rows, as follows: <tbody> Subject ID Lot Numbers 10001 9001, 9002 10001 9345, 9100 10002 9004, 9005 10002 9045, 9099 </tbody> and would like to have it as <tbody> Subject ID Lot Numbers - Grp 1 Lot Number - Grp 2 10001...

Hi Experts, Can anyone give already made the solution related topic to my subject.. Im getting an error on save as line code

I want to write a sentence only using formulas, for instance, I am comparing many things about a home. I would like to say how things are similar, superior and inferior all in the same sentence if it applies. My version of excel is not really excel at all but a spreadsheet built into my software...

Hello All, I am trying to create an Output sheet that gives me the result from the Input sheet. The input sheet match all the similar criteria with other two sheet (Table array 1 and Table array 2). I tried to combine the formula in the Output sheet to use only one column, but to have order...

Hi everyone, I am tring to integrate in my formula some data more to make an automatic order in the cell but I don't have no clue how to solve it.:confused: For example if I want to match two column with this formula =IF(ISERROR(VLOOKUP(C2,$A$2:$A$6,1,0)),"",C2), the result will be like this...

Hi Excel World! I've spent the last couple hours trying to find an answer in one of the forums regarding how to do a mail merge with a unique subject for each email from a column in Excel with no luck. I am new to VBA but understand some of the coding language used. Simply put I would like to...

Hello All, I am trying to use an excel formula that calculates for me the match of two columns and show me the results. If I want to calculate one column I am using this formula: =IF(ISERROR(VLOOKUP(E18,A18:A22,1,0))=TRUE,"",E18). It's working really good, but it's seems impossible if i want...