This is a clever way to get the signature, but the default email body has a couple blank lines above the signature, and those are getting included when you concatenate the email. Display 'This will open the message itself. 'Thank you for your attention in this matter.' & '' & '' & _ 'If you have any questions and/or concerns, please contract your Relationship Manager, ' & Cells(cell.Row, 'B').Value & '.' & '' & '' & _ Subject = Cells(cell.Row, 'A').Value & ' - ' & 'Documentation Request' _ 'If LCase(Cells(cell.Row, 'Z').Value) = '' Then 'Testing if statements - The below one works perfect (Cells(cell.Row, 'H').Value) = 'yes' Then LEI = 'Legal Entity Identifier (LEI) - ' & '' & '' If (Cells(cell.Row, 'O').Value) = 'Needed' Then If (Cells(cell.Row, 'N').Value) = 'No' Then If (Cells(cell.Row, 'M').Value) = 'No' ThenĪFS = 'Audited Financial Statements (AFS). SIP = 'Statement of Policy and Guidelines (SIP&G) - ' & '' & '' If (Cells(cell.Row, 'L').Value) = 'No' Then 'Statement of Policy and Guidelines (SIP&G) If (Cells(cell.Row, 'J').Value) = 'No' ThenĬonDoc = 'Constating Document. If (Cells(cell.Row, 'I').Value) = 'No' ThenĪccOpen = 'KYC Account Opening Form.

Set OutApp = CreateObject('Outlook.Application')įor Each cell In Columns('G').Cells.SpecialCells(xlCellTypeConstants) Thank you for your attention in this matter.ĭoes anyone know how to fix it. My email populates almost perfectly, except for the fact that at the end, there is about 3 lines of space between 'Regards' and my signature. I have everything working except for 1 small detail and I do not want to use this until I have that 1 detail figured out. VBA & HTMLBody - Spacing between Body and Signature I will be using excel to send emails to my clients requesting certain files from them. 'The following document is ready for your review. BodyFormat = olFormatHTML ' send HTML message Set objMsg = Application.CreateItem(olMailItem) StrTrackingNumber = InputBox('Please input the Tracking Number') I can't seem to figure out how to concatenate the variable 'strTrackingNumber' into the complete hyperlink. An email is then generated in HTML with a hyperlink containing that variable. The user inputs an answer to a question which results in a variable storing that data as a string. Outlook VBA variable into HTML Body - html I created an Macro in MS Outlook for an email.

Outlook vba insert email separator line