.body

Hello, I am trying to write a code that will send an email with a specified body as a string in this code its dim as strbody and i want the the HTMLBODY to include my outlook signature. I can only get on or the other to work but never both at the same time. The code sample below is just...

I am trying to get my UI to open and send email with the text box data but every time i open the email it will only past the last textbox i need a simple fix? Private Sub Submit_Click() On Error GoTo ErrHandler ' SET Outlook APPLICATION OBJECT. Dim objOutlook As Object Set...

In the code below I specify the body of the email using a series of cell references from my workbook. Can I use the same approach and use .HTMLbody instead of .Body. I want to be able to format the body of my message or make it appear more aesthetically pleasing for the recipient A line below...

Hello everyone, I have a monthly report I export as a PDF and email it to some ppl. It is a huge report and I am trying to export the report in a Ledger paper size, but I can't get this done. I would like your help on this,if possible. This is the VBA code I have so far Public Function...

Hello. I have a VBA that is pulling files out of excel and creating emails. I have an extensive master list with potential files, which may or may not be found on a given week. My issue is, when it runs, if it cannot find one of the files, then the module stops. Is there a way that if a file...

I have names of various workbooks in Col A and the email address to cc on col B pertaining to the file name I have the following code below to email and allow a user to attach a file Based on the name file attached, I would like the code to look up the email address to cc in Col B based on...

Good morning, I've used code below with previous versions of excel with no problems, but now that we have changed to Office 2016, it doesn't seem to work. Here is the code that should create a .pdf and send it via email, without it being displayed: Sub Create_and_SendPDF_Sheet1() Dim...

I have the following code to enable a user to attach a workbook and to email this I would like the section of code containing .Subject = to contain the "Summary Sales figures for + the name of the workbook attached or eg if name of workbook attached is BR.xls then .Subject = must appears as...