signature

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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