Category "vba"

Insert Signature in Outlook Email

I found this code, but it doesn't include the signature. In all the resources I've read, I couldn't come up with a solution. Public Function Email_Test() Dim

How to include signature on email?

I have a code that sends an email too individuals on a list. I need the user's signature to appear at the bottom of the email. I cannot get it to display. B

How to set alias as the From account?

I have VBA code in Excel that sends an email via Outlook 365. My primary email account (@outlook.com) has five aliases. These are not separate email accounts b

how to get real formula from EXCEL formula

| A | B ------|-----|-------- 1 | x | 1 2 | y | 2 3 | z | 3 4 | a | =B1*B2+B3 Imagine the above stuff is part of an ex

Macro send email, change 'from' Display Name but NOT email address

I have this: .SentOnBehalfOfName = """Customer Service"" <[email protected]>" the name "Customer Service" is officially associated with the

disable editing in cells without protecting worksheet vba

I want to disable cell editing (direct typing into cell) but want to update that cell through code without protecting worksheet Does anyone have any idea?

Replace text using RegEx in Excel-VBA

I have data in Excel like follows (one row here - one cell in Excel): 07 July 2015 12:02 – 14 July 2015 17:02 12 August 2015 22:02 – 01 September 2

Cannot run the macro. "The macro may not be available or all macros may be disabled"

This topic has been already mentioned, however without a solution. I have a very simple Macro calling other workbooks and their macros to execute: Sub Execute(

The loop over two arrays take LONG

Thanks for your helps, I have two arrays: A (100k row, 10 col) and B (100k row, 12 col) The following code (thanks to BSALV) loop through A and B => It takes

Run CATIA VBA macro in batch mode from Visual Studio

I have created a VB class to manipulate a CATIA project. The VB code is compiled into a dll loaded into a C# project. Imports ProductStructureTypeLib Imports I

Run CATIA VBA macro in batch mode from Visual Studio

I have created a VB class to manipulate a CATIA project. The VB code is compiled into a dll loaded into a C# project. Imports ProductStructureTypeLib Imports I

VBA Issue Excel

i am trying to add a translator in Excel, but i can't figure out where the mistake is in my Code: I am trying to add a translator in Excel via VBA. The problem

How to copy rows x times based on cell values into another sheet, & create a new column filled with specific content?

I'm very new to VBA and I'm struggling with something I can't manage to succeed. I have several columns, some of which work in pairs : the first element of

Sending Email with attachment by MS-Outlook in VBA, Excel when Outlook is closed

When I send mail free from attachment, works truly. But when I using the .Attachments.Add ActiveWorkbook.FullName parameter, it does not send and been pending

Getting Outlook Redemption to work on 64-bit operating systems?

Our servers are upgrading to Windows 10 64-bit (which is also using Office 64-bit products) and I noticed that in this environment, the old Outlook Redemption c

How to access EmbeddedItem attachment in Outlook VBA

I am using Outlook 2010 and the QuickSteps only allow to create a Task from an email with the email body copied to the task body or with the email as attachment

Why can't I `End` code while I'm subclassing without breaking everything?

Context I've written some code in VBA to subclass a userform so that ultimately I can intercept WM_TIMER messages being dispatched to it. I'm doing this instead

Getting specific cell data from SAP to excel

I am trying to get data from specific cells in a row in SAP, into an excel table using VBA. When I record a macro of me clicking the 5-6 items I need, it only g

Clear filter from Table

I'm trying to run a macro that replaces data in a table in Excel, when the data might initially be filtered. The code should remove the filter first, then run

How to get Microsoft Exchange email addresses other than the primary SMTP address using VBA

I'm attempting to pull contact information from an Outlook.ExchangeUser object using VBA in Excel. However, so far I've only been able to get the primary SMTP a