tempfilepath

  1. N

    VBA Help - Email using different email address

    Hi All. I am currently trying to use a macro to pdf each individual sheet to email addresses in B2 of each sheet. This works perfectly. However I want to email using a different email account to my default one. This doesn't work perfectly! I have two seperate VBA scripts, one for PDF and...
  2. B

    Create Temp Copy of Workbook to Email (Ron De Bruin Code) - TempFilePath Environ Issue

    Hi Community, Hoping you can help with an error i'm encountering when running a script to create a temporary copy of the workbook > attach it to email and send using outlook. I get an error on: TempFilePath = Environ$("temp") & "" The exact error message is: "Compile Error Can't Find project...
  3. T

    VBA Code to send two separate Emails

    Hi All, The below code is currently part of one of my subs, It’s toautomatically send an email when a button is pressed in the worksheet. Myquestion is how can I change this to make it send two separate emails withdifferent bodies and recipients? Thanks in Advance Tom Dim wb1 As Workbook...
  4. T

    Send Email from Excel - Error in Macro

    Hello, I came up with the below code in order to send an excel file from VBA leveraging outlook. While some part of the code works, I'm stuck when Excel is not opened /or is opened. I got an error. I have highlighted the part I'm struggling with in red. Any idea what I have to adjust? Thank you...
  5. C

    VBA Save_Email_Delete Sheet

    Hi, I have a workbook that I would like to save a copy in a particular folder with naming. I would then like to email it, and then close the file. I have used the below macro for this, however users are receiving an error on line: With Destwb .SaveAs TempFilePath & TempFileName &...
  6. N

    VBA - Email selected cells from a worksheet via email

    hi All, I am stuck on this for 2 nights and I cant find a solution on the internet. Maybe it just doesn't work. What I am trying to do Attach two different tabs and attach them as attachment. With the current tab - Put some few rows in the body of the email Then save Rows 43 -95 into...
  7. S

    Change the body of an email with VBA code

    Hello, I am working on automating email for my workbook using the below code and need to add more content to the body of the email. I have seen a few examples of how to add more lines but have so far been unable to get anything to work. Please can anyone advise? Option Explicit Sub...

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