excel & email

Hello, I have the following sheet that when the user saves it then copies to an email but it is cutting off the last few columns. The VB code I am using is as follows: Sub CreatePNG(Namesheet As String, nameRange As String, nameFile As String) 'ThisWorkbook.Activate...

Hello, I am very new to VBA and trying to find out how to make this work. So basically I have a Checkmark from D2 to unlimited. When Checkmark is clicked > Display Message I have the following code written so far but I don't know how to display my message without having to run the...

Each month i have a standard email in outlook that i write, but i have to change a bunch of numbers in the text based on data i have in excel. can i automate that process?

Hello! I'm new to VBA, this is honestly my first time playing around in it, and I need some assistance. I have a group of cells on my excel sheet that I want to have copied and pasted into the email body, but everything I try comes up with nothing. :( Could anyone help? I also really need my...

The aim is for the code to generate the pdf, save it and attach it to an email in outlook. The following error appears: Runtime error '1004': The document was not saved. It may be open or there may have been an error during saving Private Sub CommandButton13_Click() Dim ws As...

hi all, i am trying to do this without vba or macros. Mailto hyperlink: [table one] has the drop down list of names, information columns and email link on the same row. [Table two] has the email hyperlinks referenced by the email link in ]table one] that's based on the name selected from the...

Apologies if this is completely basic, but I can't find anything in the forums that directly relates to what I'm trying to accomplish. I am not at all schooled in anything VBA, technical Excel, etc. I just Google to figure things out, and here I am! Here's my starting point: I have a workbook...

Hi, I am basically trying to add text from a cell into the body of my email, I have tried doing it myself but have no luck in getting the text to appear. I am looking to include cell reference D48 from the 'D&P' tab of the current worksheet, and ideally the text from the cell would be be...

I have the below spreadsheet where I can use a form Checkbox to set a value in columns (B,D,F) to true or false. From this point, what's the best way to generate an email with all the cells that were checked using the below example (VALUE=TRUE) in the respective places (e.g...