outlapp

Hello, We are seeing this error only on one computer. All 6 pc's are running same version Excel 2016. When we execute the macro below the error occurs at the "With OutlApp.CreateItem(0)" area. Any ideas? Thank you Sub AttachActiveSheetPDF() Dim IsCreated As Boolean Dim i As Long Dim...

Hi! I have been browsing the forum and found a very good code for sending an excel sheet as PDF on e-mail by a user ZDI (?). I modified it a bit - picking cell-references into the body text of the e-mail, subject and To/Cc fields. The code looks like this now: Sub AttachActiveSheetPDF() Dim...

Hi all I am using the below code to send a PDF to a group of managers. I want to include in the email body, a summary table from one of the tabs. I want paste as an IMAGE as this keeps all of the formatting and size ratio that makes it easy to read. The source tab is called DATA and the...

Hello, i need to form body text from excel to send via outlook. One problem, that sometimes in can be 10 names and surnames, or it can be 5 names and surnames. After list goes normal text and signature. I have this one, from K20 goes fixed text, but from K12 until K20 goes list of people...

Hey, I have this code. But I need to bold text from cell K14 and change color of cells K21-K25. How can I do that? Please help :( Sub SendMail() 'SendEmail Macro ' ' Dim outlApp As Outlook.Application Set outlApp = CreateObject("Outlook.Application") Dim outlMail As...