Outlook Macro
I have created some email templates that I would like to create a shortcut to on my Outlook ribbon. I believe the macro is incorrect (see data below). I saved my template as "Closing Tools Invoice.oft" and plugged the file name into the macro below. I was then able to add the template menu to my Outlook ribbon (seen below), but when I click on the icon, an empty email pops up. Nothing in my template at all appears. Any idea what I might be doing incorrectly? Thank you for any help you can give.Outlook Templates
I am trying to determine how to do something I'm not even sure is possible. I took a couple of screenshots below to show my issues. I should probably break this into 2 separate emails since they are really two separate problems. Intent/Background: I utilize two different email addresses at work. These are my default email that comes from my name, and a central AR mailbox. I send emails from the AR mailbox FROM: AR Inbox TO: outside recipients CC: inside recipients Subject Line: Invoice <#####> Body of email: <attachment>, a basic please find attached your invoice, and the signature line of the generic AR. NOTE: I cannot have anyone see that the email is coming from me, so it is important that I don't "FORGET" to change the "FROM" line. What I have attempted: Created a template. This works PERFECTLY, with one big exception. When I open the template, it defaults to my personal email address, not the central AR box. Is this even possible to do? Quick Step. This does not work because I cannot change the FROM and I cannot add the signature to the email due to the image that's included in our signature. Thank you for any help you can give.
I need to write a Macro that when run will hide rows
I am creating an order form for a small business. The form has all of the items available to purchase. When an employee works on an order for a customer, they will put a quantity in the "Quantity" cell. I want the macro to hide any row that has a quantity of "0". This is my first attempt at writing Macros, so please be very specific. The screen shot is of the order form as it is currently designed.
