emailed

I have tried to write code to insert "NO" in col I where "Emailed" does not appear or Col I contains a blank row For eg if I2 contains "Emailed" , "Emailed" must remains, If I3 is blank , then "NO" to be inserted I get a type mismatch when running my code If Range("I2:I" & LR).Value <>...

Hi guys, I have a list of files which have been created through another vba I created but now not sure how to apply said password against each of these files. I know I need to create a loop but not sure how to do that in this case. Furthermore after doing this, each of these files needs to be...

Please Help I am running my payroll through excel and currently printing everything. I am looking to email everything instead. I want to be able to click a button and each employees paystub be emailed to them. Not sure if this is possible with a Macro or what coding to use. Thanks Greg

Hello All, I'm an adjunct instructor. My Excel tests and homework are "shared". Usually I can catch them when I review the formulas because I recognize the same formula error or weird spelling. Is there anyway stop sharing files especially during a test. I just had a case where one student...

Hello, It's been brought to me to see if this can be done. We have a spreadsheet contain information for our quality department. After someone enters information in Column H they would like that row A thru I to be emailed to bunch of people. If someone leaves column H blank we don't want it...

Hi I am providing Customer Reports which consists of a Dashboard with no external connections but many linked tables and Vlookups. I do this for other Customers with no problem. However when I sent (emailed) the most recent report they reported that although the file opened none of the table...

any suggestions on how i could do the following? What i'd like to do is loop through each row, in a spreadsheet then pull the order number and generate an email to the correct department stating: "Hello, the following order, (pull order number from order column), requires additional action by...