subject

  1. D

    Formula in Excel to display email message with CC & email receiver

    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...
  2. Y

    Macro to send email based on ComboBox

    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...
  3. R

    Auto save to PDF and email macro

    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...
  4. S

    Search a table and return rows based on criteria of 2 cells

    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...
  5. V

    I want to extract all details form outlook emails in excel using vba according to particular word in subject of email

    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...
  6. M

    Retrieving Argument fro PS within VBA

    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...
  7. S

    SendMail Macro in Excel 2016

    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...
  8. P

    Email to excel

    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...
  9. A

    Aggregate data from multiple sheets and pull based on value in row and column headers

    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...
  10. S

    Want to find sum of Top 70% students' marks

    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...
  11. S

    Show cell number or text by referencing several cells and select the highest of all(more than 3 items)

    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...
  12. P

    Moving from Sequental Rows to Columns?

    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...
  13. V

    Save outlook mail draft copy on local drive

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

    Need help with a chart and formulas for making sentences based on similarity or differences, proximity and date of sales.

    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...
  15. M

    Excel formula combine in different sheet

    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...
  16. M

    "Sort by" Formula

    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...
  17. A

    Mail Merge with unique Subject, CC & Attachment using Excel & Word 2013

    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...
  18. M

    Multiple table array

    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...
  19. K

    Changes Subject Corresponding to Email Address

    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...
  20. P

    Vba to move emails from Inbox to personal folder

    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...

Watch MrExcel Video

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top