signature

  1. A

    Digital Signature

    Hello Everyone, Happy New Year ! Hope you all had a nice time with your Family, Friends, Relatives.. Starting a New Year with a new challenges on Excel ! :) Basically I'm trying to build a 'Goods In' spreadsheet. Made the macro which gives unique ID for each delivery we are getting in...
  2. D

    Excel page break between Table & Range

    Hi! I got a page break challange in Excel (2016) worksheet. I have a defined table containing statement of account ("Table1") - the table is autoexpanding and populated with a copy-paste function over VBA. The table area is followed with a signature area which is not changing, but taking...
  3. M

    VBA grab email list from table in another sheet and use as send To

    Hi there I have the below code which I know is incorrect for the To. but I don't know how to fix? would appreciate any help. I have the list on another sheet. It's in a table if that helps: Table16[Email] Sub emailsavePDF_weekly() Dim objOutlook As Object Dim objMail As Object...
  4. M

    Find and Move Last hpagebreak

    I have a 3 row tall signature block that is inserted 4 rows below the bottom of a dynamic table. I want to insert code that will ensure that the signature block never gets printed between 2 pages. I'm looking for code that will find the location of the last hpagebreak, compare it to the...
  5. S

    get and past htmlsigniture from outlook into excel

    Is there some way to read the outlook signature html file and paste the signature to the end of an excel spreadsheet?
  6. C

    Email w/ signature issue

    The code below is getting the signature an adding it the email. But it does not copy th picture portion of the signature. It gives a box with a red x the picture can't be displayed. Can anyone please help me? Sub testemail() '-----------------------------------------...
  7. A

    Outlook VBA - recurring task to send email

    hi folks, I have found a great way to send out reminders to submit work to a group of people based on a recurring task. https://www.datanumen.com/blogs/auto-send-recurring-email-periodically-outlook-vba/ in ThisOutlookSession, you paste the following code: Private Sub...
  8. V

    Trouble with signature macro

    With the help of the forum I have a signature macro that had been working fine, but recently has been putting the signature of the person that last opens it into the file (suppose to be the signature of the person that performs the recon) Below is the code that I have ben using (work sheet...
  9. C

    Button with moving cell reference

    Hi All, I'm not sure how to do this so hoping you can help I have a button on an excel form and when you click it, it send an automated email to someone to say they approve the document. What I would also like is for it to put the date they clicked the button and their user name into...
  10. P

    Add signature to Gmail

    We recently migrated from Outlook to Gmail. My Access VBA utility that sends emails had the feature of including the Outlook signature. Unfortunately I can't figure out how to include the Gmail signature in code, i.e. there is no equivalent to the Outlook code OutMail.HTMLBody = body &...
  11. J

    Adding a signature or image after body of text ??

    Hi if some one could please help me add a signature or image to this code i would be very grateful. Sub twosaves() Sheets("Quote").Select ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, _ filename:="C:\Users\James\Documents\Excel Test Folder\Quotes PDFs Test\" & _...
  12. J

    Add an email signature/or image of signature to VBA Outllok Email Body.

    Hi everyone, i have created an email quote template, however i would like to add my business signature, or a picture of the signature to the end of the body of text. If anyone has any suggestions please assist. Thank you . Sub Send_RangeI() Dim strPath As String, strFName As String...
  13. Roderick_E

    VBA .send vs .display 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...
  14. H

    Signature Line Help

    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...
  15. V

    Signature Macro

    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...
  16. H

    VBA: Email cells as a picture through Outlook plus add text and signature

    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...
  17. M

    Digital Signature in Excel

    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...
  18. V

    Electronic Signature

    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...
  19. A

    Anyone ever use excel on a tablet for signature sign offs?

    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...
  20. R

    [HELP] Macro Email Signature with Picture

    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...

Some videos you may like

This Week's Hot Topics

  • help please
    SORRY NOT ANY GOOD AT EXCEL SO HELP WOULD BE MUCH APPRECIATED this formula is in a sheet called ignore...
  • two formulas needed
    Hello, I'll try my best to explain this: First formula needed in Sheet1 cell A2: If Sheet1 cell B2 = Sheet2 cell B2 then return a 1. If not then...
  • Dynamic Counts
    Good afternoon, we are tidying up some data & the data seems to be growing quicker than we are tidying it up! What we confirm (by reviewing it...
  • Help Excel formula eliminate duplicate values and keep only 2 identical rows.
    as picture below column A has a duplicate value. but the values are not the same as the rule. sometimes 4 rows, sometimes 10 rows or 7 or 9...
  • Macro Compile Error Sub or Function not defined
    Hello, I am trying to run macros from a validation list, all macros have been created and run perfectly on there own but I'm getting a compile...
  • Last row combined with Current Region VBA
    I'm generally happy finding the last row of data through something like Lastrow = Cells(Rows.Count, "D").End(xlUp) but I don't always receive data...
Top