signature

Dear Mr. Excel, I have the following codes that attempt to do the following, once an email is selected in MS Outlook: Include all the recipients in the selected email Copy the original attachments that came in the selected email Reply with a designated text, along with default signature and...

I am using a addin form for signature on excel sheet I press done command button after signature is inserted in worksheet the addin form is unloaded but it unloads all vba projects I am trying to return to main form. If I put in code before OLEObjects.add which puts signature on worksheet it...

I'll do my best to explain what I would like to accomplish but I have zero experience with VBA and I haven't been able to piece together anything that works. I use Outlook 2010 and I have several different signatures. I have HTML and plain text versions of each signature so the VBA code needs...

I have a worksheet in workbook1 that complies information for the other worksheets and at the end of the day I need to export that specific worksheet to another workbook. So far I have no problem doing this, but the signature lines (8 total in a specific cell range) that I have there are not...

:confused:I am having trouble creating VBA to delete specific objects in a worksheet before I copy that worksheet to a new workbook. I have several macro buttons and signature blocks in worksheet1 and when I click my export button I need the macro buttons to go away but the signature blocks to...

Good afternoon, I am curious if there is a reference tool that would provide all of the options available in a specific reference library. For example please see the code below. You'll notice that it says 'or use .Display.' I know from previous macros, you can also use .Save as well. However...

I use the following code to copy a range of cells and paste it as an image into a new email: Sub Email() 'Copy range of interest Dim r As Range Set r = Range("A1:E24") r.Copy 'Open a new mail item Dim outlookApp As Outlook.Application Set outlookApp = CreateObject("Outlook.Application") Dim...

Have been playing with signature boxes, etc. Would like to use the inkpicture feature but don't like the active x turned on. If you feel this is the better option and I can turn the active x message off with code when workbook opens, then feel free to share. I'd at least like VBA code to select...

Good afternoon. I'm hoping you all can help me (again). I have a directory that is a repository for forms created in excel. All the forms have the same format. Re repository may contain hundreds of forms in various stages of completion. A form is "complete" when all the required reviewers...

Hello. I'm brand new to the forum and have been "lurking" for a solution to my problem for a while. This subject has been discussed to a certain degree on other threads and I'm sorry if I'm reopening old wounds. I have a worksheet that my company uses as a form. On that form, there are...

Hi Is it possible to create a macro to apply a digital signature image to an excel file? i know Excel has the function in INSERT > Signature Line - where you add in your details and can select an image of your signature, but i would like to automate it into a macro to run and apply it to an...

Hello, I reviewed suggestions provided in Ron de Bruin page. I need help in streamlining the below code. I need to Send email to a list of users. I did changes which I guess is not working. :confused: The code does not pull the signature even after me changing the sign file name I need the...

Hello everyone, I posted this in the non-excel forum to no avail, so hoping it will get traction here, as this forum notes you can post VBA-related questions and that is what this is. I have some code here that currently works to create a reply, take the sender's name, and put it in the...

Hello everyone, I have some code here that currently works to create a reply, take the sender's name, and put it in the greeting. It also adds wording for the body and then a signature. What I need to do is get Outlook to pull all the names from the sender field and be able to add them to...

Thank you ahead of time for the help. I have some vba code that has been working flawlessley on my machine. Essentially, I use vba to create an email and attach a personal signature from outlook. The part of my code that has worked and is now in question is this: SigString =...

Hi People, I have the macro in Access which is sending e-mails for each record within query: Set olApp = CreateObject("Outlook.application") Set olItem = olApp.CreateItem(0) vitems = Slownik.items vkeys = Slownik.Keys SpolkaString =...

Hi guys, Hoping that you can help me with adding an outlook signature to the code. I have added it in the past using outlook to prompt (.display) method (from Rondebruin) which is the second part of the code however this method which was given to me by a consultant is different - it uses...

Hi team, Previously I used Dim signature As String / ObjMail.HTMLBody = strHTMLBody & ObjMail.Body which used to get the default signature when the macro was executed, however since implementing a PDF attachment, it no longer works. I also tried to create a path to the signature folders but...

I'm trying to find out in code not just whether ThisWorkbook has been signed (by checking the .HasVBproject and .VBASigned booleans), but who signed it. After all, one of our clients might themselves get a certificate and sign one of our artifacts, so a security check based on just a signature's...

Hello people, Ok, so recently I was asked to add a digital signature to our excel documents, but request specifically states that this signature must be like another file we use where there is a macros that inserts Something like this: <tbody> Approval from isy1214 at 11:14:18 a.m. 15/03/2017...