wfile

Hi Might be quite complicated but can I have a macro preparing to send the data as an attachment to the email but also as a table in the body of the email ? I have this macro for the attached file Sub Mail_Sheet() Dim wPath As String, wFile As String, dam As Object Dim wMail As String...

Hi, I'm wondering if there's an easier way to do this, which is user friendly and can cope with new accounts being added. Currently I have the below code, which works great. However, I have 100 accounts and the below code is for just 3 accounts. It is going to be very time consuming writing all...

I had this code which work pretty well from this user here. https://www.mrexcel.com/forum/excel-questions/1103982-vba-send-emails-attachment-base-path-folder-4.html But need someone to help. Possible to move send email to ARCHIVE Folder once email sent on outlook In outlook, there is a SAVE...

Hi, I have this code for file path for the Invoice PDF. Private Sub CommandButton1_Click() Dim NxtRw As Long, CurrentPath As String, wFile As String On Error GoTo EnEvents If Range("J3").Value = "" Then NxtRw = 3 Else NxtRw = Range("J2").End(xlDown).Offset(1).Row End If...

I keep getting the error 1004 saying document not saved in this code that saves to pdf and emails ? what is wrong with it can any one help ? Sub Send_Email() Dim dam As Object Dim wPath As String Dim wFile As String Dim x As String Dim wf As WorksheetFunction Dim...

Hello all, I'm trying to modify my code in order to close a workbook after it's served its purpose. I've placed the code below. I'm currently receiving a Compile error: Type mismatch. The file I'm opening has "CHARTER_REPLEN" in the name, but it also has a date stamp before the portion of the...

Hello, With some help from a fellow forum user i have this code: 1) The issues are i want it to save the file name as "x" which is tomorrows date and save it in a network shared folder. 2) i also want to include a image for my company logo after my position. in the body of the email which i...