outlookmailitem

  1. V

    Error file path in not correct while attaching in email

    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...
  2. D

    Modification of VBA code

    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...
  3. V

    How to have Attachments based on a cell value VBA.

    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...
  4. R

    Help with Dynamic Emails

    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"...
  5. B

    Save worksheets as separate PDFs and then e-mail them to separate recipients

    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...
  6. E

    save in PDF and SEND the same by outlook

    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:= _...
  7. D

    Email to Multiple Recipients with attachment

    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...
  8. D

    VBA Email from within Excel got it kinda working but...

    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...
  9. D

    Trying to get Excel to send a sheet as a PDF

    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...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top