1. J

    Forced to discard digital signature after opening and immediately saving an Macro-Enabled Excel file

    Hi all, so recently I've made some changes to a .xlsm Excel file and then digitally signed it. I then opened the .xlsm Excel file and saved [CTRL + S] immediately without doing anything. An error message saying that "You have modified a signed project. You do not have the correct key to sign...
  2. C

    How to VBA things for weekly email

    Hi all Learning VBA slowly on my own and I have managed to write a script for me to send multiple emails weekly, however there are 2 things I would like to do…. when referencing a cell in the email body which is a negative value, I would like that text to be red, and a positive value the text...
  3. Y

    How do stop VBA pasting content under default signature in Outlook

    Hi all, I'm completely new to VBA but have managed to piece together a few things I found online, and mostly understand what it's doing. In order to copy specific cells from Excel and paste them into an Outlook email whilst retaining their appearance, I have the following code: Private Sub...
  4. 2

    VBA Outlook Signature Formatting

    Hello, I am attempting to insert my default signature at the bottom of some automatically generated email. The contents of my signature have been copied, however, it lost the formatting. Here is the code I used. Set OutApp = CreateObject("Outlook.Application") Set OutMail =...
  5. A

    Insert Transparent .PNG Signature to Workbook?

    Is this possible? Have a few templates I'm looking to add dynamic signatures to from a dropdown and save to .PDF instead of printing, manually signing and scanning in. I have signature images in PNG format that I'm looking to overlay over the signature line. I've looked into the...
  6. Z

    store signature

    hi can i check with you guys, am i able to store signature in a cell. For example, i store "Peter" signature in a cell. Then in a new sheet when i create a list ,i will want to use lookup function to extract "peter" signature. i know how to use the fuction. i just want to know is storing...
  7. I

    How to edit this email from Excel VBA code to put body text after pasted info with signature?

    Hi. I have this VBA code that copies the current range starting from A1 and emails it out. It works however, the body text gets put below the pasted info and there is no signature. If I remove the body text the signature is there. How can I edit this to put the body text on the top and still...
  8. randaubienghoc

    Send bulk email from Excel issues: 1-Attach multiple files with file paths, 2-Copy visible ranges and 3-Add default email signature keeping formats

    Hi everyone, As a new VBA learner, I am seeking for your help to solve these three problems when automatically send Outlook email from Excel. The code is now lacking these improvements. Your support would be highly appreciated. 1. Attach multiple files with file paths by criteria (For same...
  9. J

    Sign a PDF from Excel VBA

    I have been searching for an answer in different forums without success, so I decided to open a post. Currently, I generate a PDF file from a range or a worksheet in Excel. What I need is to include a signature in the PDF file. This is the code that I gather from different sources to open the...
  10. D

    Make an image snap to a page

    I have a button that inserts a signature at the bottom of a sheet under the last row but if the rows are nearing the bottom of the page, the signature image will be pasted half on one page and half on the next page. Here is the code to paste a set signature and code to paste a custom signature...
  11. P

    VBA Outlook message formatting issue with Chart insertion

    I have VBA code that would open an new email and I want to add : Hello, <Email body text stored in as String Variable inserted here> <Chart copied from Excel inserted here> <Standard Signature inserted Here> I have the following code. It all works except that the Chart is inserted after...
  12. K

    Default Outlook Signature when generating email from VBA

    I have done a good bit of searching to modify some existing code to include the default outlook signature, but I haven't had any luck. Any help is appreciated I have cut the code to barebones in an effort to simplify. Sub create_Email_test() Dim oApp As Object Dim oMail As Object...
  13. D

    VBA email signature from secondary account

    I have a problem choosing the correct signature when sending mail from Excel via Outlook (Office365). I have 2 accounts set up in Outlook, one is primary email and the other is secondary email with both having different default signatures. Secondary email is a shared mailbox, but added as a...
  14. C

    EXCEL 2016 Send an email with signature

    I need to compose emails using VBA with signature in EXCEL 2016. I followed an tutorial on YouTube. This is the code I used, exactly same as the youtuber's but it works on his computer, not mine. Sub PrepareEmailNow() Dim olApp As Outlook.Application Dim olEmail As Object Dim sig...
  15. T

    Outlook VBA way to differentiate between attachments and embedded images?

    I'm trying to prevent myself from accidentally sending a file to someone outside of my organization's domain. (We've all hit the "reply all" button and sent something to someone we didn't know was in the email chain, right?) I've got some code I found online, but it doesn't make a...
  16. C

    Setting up a personalized body and attachments to outlook from excel

    Hello, I found/modified the below code, which is pretty close to what I need done. <code data-editor="34b16c" data-block="true" data-offset-key="edq1k-0-0">[CODE]Sub MailBlast() </code><code data-editor="34b16c" data-block="true" data-offset-key="628t3-0-0"> Dim xRg As Range </code><code...
  17. L

    Send selected Range cell in body and using outlook signature

    Hello everyone, I have this VBA code which works great, I am trying to include rage selection. So in order words I want it work like the Sub send selection code. How to I incorporate the sub selection code with the below code. Sub Send_Email_With_Signature() Dim objOutApp As Object, objOutMail...
  18. B

    Keeping default signature when sending emails from Gmail using vba macro

    Hello, is there a way to keep the default signature associated with my gmail account when sending an email from Gmail through VBA (I am using CDO if that can be helpful). Below is the bit of code relevant to the email configuration: everything works fine except for the missing signature. Any...
  19. J

    Convert Excel to PDF with empty signature box

    Hello, We have an excel macro (vba) that converts our worksheet to pdf. However, we are trying to figure out a way to add signature boxes to the converted pdf file in an automated fashion. Can this be done via VBA? If so, how? TIA, Jay
  20. C

    Email Signature

    Can anyone help i have peaced together the below code through using Google and a bit of trial and error, I have created a macro to send an email based on data in a spread sheet. My problem is the email signature does not display the pictures can anyone help? see below code Dim xOutApp As...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back