subject

Hello Everyone, I am a teacher and my school timetable changes weekly. I am trying to write a formula to check that my timetable does not clash with other classes. I teach accounting. There is a master timetable with all the subjects for one group of students, then the subject timetable are...

I wrote this simple script to auto populate info that i do several times a day. When i runt he script I want to be able to add additional information on the subject line. Right now the typing focus is after the to: email, how can i get it to be at the end of the subject line? Sub actupd8() 'Add...

Hi All, does any know how to set an active range as email subject? case like i may select certain cell or range and want it send out as email subject. ActiveWorkbook.EnvelopeVisible = True With ActiveSheet.MailEnvelope .Introduction = "" .Item.to = ""...

Hello All! I have been searching and searching and cannot seem to find something that will help me. Here's the gist of what I'm trying to do: The user will receive an email with a link to an Excel file in it. When the user opens the file, I would like to trap the subject of that particular...

Hi All, Some help please. I'm trying to write vba code that runs on new emails that are already in a shared mail box or arrive at that same shared mailbox. The emails will have a specific subject such as "Output for PS2 model" in the subject line with a crucial difference being that part of...

Hi Excel Experts, I am a newbie to this forum (and much of Excel's functions). I am wondering if it is in any way possible for me to come up with a formula for the following problem: I have 3 columns, for e.g.: SubjectID Full path to Pic1 Full path to Pic2...

Hello Guys! 2nd time posting in the forum :) My first question was promptly answered by one of us so very much positive that someone could again help me with my problem. It's probably something basic but I don't have much knowledge about formulas so... I'd like to include the person's name on...

Hi There! I need some help to sum up the value for drop-down list. Each item in the drop-down list should have a value tagged with it. This is the scenario: <colgroup><col><col><col><col><col><col></colgroup><tbody> Subject Name Type Status Appointment ID Time...

<colgroup><col></colgroup><tbody> When copying email file from Outlook to C:\ the filename is the Subject of the email. How to rename the file from Subject to Sender's email address? </tbody>

I received a massive file from a friend who has done extensive research and has been counting her results manually. We need to know for each subject (row) in the below example: Case 1. How many LIVING objects e.g. Dog or Mouse the subject answered incorrectly. (Column B = "L" and Column C =1)...

Hi There! I have been working on excel codes to restrict specific cells based on values from multiple drop-down list. <tbody> Subject Name Type Status Appointment ID Time Test Subject 1 HV 15033 Test Subject 2 DM 13588 Test Subject 3 DM 82215 Test Subject 4 RP DM/HV...

Hi All, I have a "Summary" tab that records a list of subject in column B2 onwards, in Column C1-E1 there are heading with peoples names that relate to my three sub tabs, the sub are named "David," "Mike" and "Susan". So in C2 of the "Summary" tab, I want to look at the subject in column B...

I have a macro for emailing which works perfectly, except I cannot get the subject to pull through from a named range called SubjectText B2 is named as SubjectText Book1AB1Email2SubjectSales for Aug 20173BodyAttached please Sales data for Sep 2017 RegardsSheet1 Zsubject = [subjectText]...

Hello, I'm looking for code that will open a specific Outlook template based on what is in cell H1, allow to add 3 different cell values to the subject line, then email, automatically, and then move to the next row and do the same thing until there's no more populated rows. I have 3 different...

Hi Everyone, Can someone assist with my below requirements. 1. I am receiving more than 50 plus mails (excel) in my inbox which consists the same subject called "nata" 2. I just wanna open and consolidate those excels together using vba macro. Is it possible.

Howdy ! My first post on Mr. Excel, so let me know in the comments if I left anything out. I have attached a simplified version of my project which illustrates my problem of creating a chart, when the data dynamically changes quantity, the graph gets thrown off. You can see that if you change...

I am having a student data to calculate the number of subjects failed by a student. ABSENT is also considered as fail and those who have scored below 50 marks is considered as Fail. The excel sheet designed is as follows: Roll No Name Subject 1 Subject 2 Subject 3 Subject 4 Subject 5...

Hi All, The premise I'm struggling with is to save excel attachments to folders on my PC automatically, but using a rule that looks for specific words in attachments, saves them to different folder locations. For example test in subject, in email 1, would send it to folder1. Then test2 in...

Hi Guys, Is anyone able to help with my code? I have moved to Office 365 and my email code now changes the subject line to random characters. For example 獹䰥렀绽ঈE折[꛰ˏ& Currently it is as follows and works well with 2010 and 2013. [code] Sub EmailReport() Application.ScreenUpdating = False...

Option Explicit Sub Worksheet_SelectionChange(ByVal Target As Range) Dim ptc As PivotTable, Value As Variant, Rng As Range For Each ptc In ActiveSheet.PivotTables If Not Intersect(Target, Range(ptc.TableRange1.Address)) Is Nothing Then If Left(Target.Value, 7) = "mailto:" Then...