signature

In my code snippet below I am checking checkbox2 to see if the user wants to display the email before sending. If TRUE, just send without display. Unfortunately if it sends without display, the person's default signature doesn't get included in the email. WHY??? I don't understand. Please...

I set up a VBA to automatically email a sheet of a document to a recipient and a separate VBA to send the sheet back to me. I can’t get the Microsoft Offics signature line in excel to go with the sheet when the VBA is used. And once the signature is signed by the recipient, the 2nd VBA quits...

I am using the below macro to insert a signature (jpeg file) into a set cell area. When setting the macro the signature is sized to the cell and saved (fits perfectly). When reopening the spreadsheet and selecting the macro button the signature is large and does not appear in the cell that...

Hi! Below is the code I am using and it works, it pasted the cells into an email as an imagine BUT how do I add text before the image? I want the text right before the image and it just has to say “today” Also, this deleted my outlook signature when it pastes into the email, is there a way to...

Dear all, My boss asked me if it is possible to insert PDF style digital signatures into an Excel file. She wanted each of those to represent "approval" of a request, for example: expense reimbursement, etc. A PDF style digital signature takes the place of a person's personal signature. I...

All, I am trying to set up a spreadsheet where each tab "belongs" to a individual, and would like to set up a "button" they can click that will grab a "signature image" from their files and insert in that spot. I have gone thru the post and was able to find the below code but it is giving me a...

Hope I posted this in the right spot. I am thinking for my factory of buying a tablet that has excel on it. I want to turn all of our paper copy sign offs into electronic copies. It would get rid of 8 binders full of sign offs. Has anyone done something like this? I half tried it out on the...

Hi, I'm trying to generate a macro email with my current signature but the picture is not showing correctly. The picture in my current macro can be shown in the link below. https://drive.google.com/open?id=1d4t2_k55WMWZTCGZe47b9sWwy6EOfTmP Here is my code. Function GetBoiler(ByVal sFile As...

Hi all, I've read the sticky post about signatures, buuuut the Signature bit doesn't seem to be in the Settings section anymore. Can anyone suggest how to add one, please? Thanks! Alice

Hi, I need to add a signature block and I have the code below. However it brings up a dialog box where you have to press enter to make it go away and it will add the signature and details. I need to bypass the dialog box which it doesnt seem possible so instead I was thinking of using sendkeys...

Background I have a .xlsm excel spreadsheet. Grids are overlaid on the form in such a way that each relevant field box can have data inputted into it. I also have TWO signature fields, one for the party that is sending the form out, the other for the people that are receiving the form. Question...

I am working on some code in excel vba and trying to open a word document, then add a signature to the bottom, sign it, then export it as as pdf. So far here is what I have: Sub ExportSignedPDF 'Open Word Doc Dim WordApp As Word.Application Dim WordDoc As Word.Document Set...

How do u make a signature? it says sorry, you are nor eligible or something like that?

Hi, I'm trying to click a hyperlink that will open a new e-mail with Outlook and the e-mail would be all filled with values from Excel cells. Here's what I got so far: =HYPERLINK("mailto:" & R1530 & "?subject="& CONCATENATE(A1530," ",B1530) & "&body=" & CONCATENATE("HI","YO",C1530)&"hello"...

Please help wherein i want to add the outlook signature using VBA macro.. Can someone help me on this.:)

Hello everybody, OK, here's the thing, I know how to send the email, problem is, when I try to add the DEFAULT signature. If I leave it as is, the body doesn't show up, and when I get it to show the body of the message, the signature won't come up. Sub Mail1() Dim...

Hello All, I am struggling with my email macro. I found a great one online that attaches a worksheet as a PDF as I need it to, but cant get the body right. I need certain items in the body to be bold and underlined. After doing some research it seems the only way to accomplish this...

Hi! I'm trying to create a Userform with an inkpicture field (for writing the signature), a command button (to enter said signature into sheet), and another command button to clear the inkpicture field. I want to insert the signature in the current active cell and automatically resize it to fit...

Hello there! Is there a way to permanently save the signature setup information so I don't have to keep reentering the same information over and over again? Every time I have to keep filling out the below fields. I want to be able to sign off on a document instantly. I will likely be signing...

I have a document that I want to be signed twice. I know on Excel you can have a signature line but once you sign that once, the file is final and can't be edited without removing the signature line. How else can I capture two signatures?? If I could also have a cell auto populate the date and...