outlookmailitem

Hello I am new of VBA. I can generate the pdf with new name every time, however i am not able to attached latest generated file in email. it is giving me me error " Path does not exist, verify the path in correct." here is the code. please help me expert Sub sendReminderMail() ChDir...

Hello everyone, I have some VBA code written that reviews a worksheet looking for a specific value, and any rows in which this condition is met, an auto e-mail is generated and sent to e-mail addresses listed within 2 columns. I would like to modify the code to review worksheet to identify...

I'm currently trying to have the VBA running that will send the current files based on excel cells. I have a message error on the line : myAttachments.ADD "Sheet3.Cells(9, 2)" The cell B,9 currently have the following value : C:\Users\ojodoin\Desktop\Feuilledetemps.pdf which is where I want...

Hello guys, I am trying to automatically send PDF's of invoices through Outlook, and I was able to send the PDF correctly, but once I switched up the code for a Dynamic name change, I can no long get VBA to find the PDF. Below is my code: Sub sendReminderMail()ChDir "C:\Users\rbs\Desktop"...

Hello gurus, I am new to the forum and new to forums in general (I know, what rock did I crawl out from?) Anyway, I'm not too strong in VBA, but I'm decent with Excel. I have a workbook with multiple worksheets in it. Each worksheet is a person's name, and each worksheet has sensitive data...

Dear Team, Can any body explain how to save the active sheet name with current date and windows user name. Also explain how to call the same in outlook. Private Sub CommandButton1_Click() ChDir "C:\TEMP" ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, Filename:= _...

I am using the following to send an email to multiple users but it will only send to two recipients no mater how many I add. please help and thanks in advance. Sub sendReminderMail() ChDir "Z:\Attendance" ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, FileName:= _ "Z:\Attendance\Weekly...

Hiya All, I have spent hours looking over the net trying to get this to work but can't seem to figure it out. What I have is a daily meeting notes page that I fill in everyday in our meetings. This is on sheet 1. I have managed to work out how to convert this page to PDF then send out to a...

Hiya Peeps, I wonder if someone can help me with this. I am trying to get the code to select the right data via autofilter, then email the sheet as a PDF. I have the following code: Sub Sort1() ' ActiveSheet.Range("$AB$4:$AB$350").AutoFilter Field:=1, Criteria1:=Array( _ "Care...