email attachment

  1. J

    Curious problem, excel creates a PDF (with data), then when sending as attachment, PDF is BLANK

    I have tried to search and can't find anyone reporting a similar question/problem. I have a macro that filters some data, and then creates a PDF file from the filtered data, so far no problem. Then I have a macro that then sends the PDF file as an attachment in an email, but the problem is...
  2. pliskers

    Excel Full File, Attached to Outook E Mail

    I'm having trouble coming up with some code to attach an Excel full file to an Outlook E Mail. The issue is that I'm trying to have the code first save the file with a modified name, using the contents of a cell. For example: If the file is named "Sales By Customer", I have built a macro to...
  3. K

    VBA Code that CC active sheet to email address within a cell

    Hi Would be grateful for any assistance with the following: I have a spreadsheet with data on and a submit button, when this submit button is clicked, the below VBA code attaches the spreadsheet and emails the file to the address shown in the to box using outlook. This all works fine...
  4. B

    Break data into files when store # changes & prepare email

    Hello. I’m hoping someone can assist or point me to a solution to what I’m looking for. Below is an example layout of my datasets. I have a spreadsheet with 2 tabs. The first tab has a list of all repairs that are in the building. The second tab, has all the store email addresses. My goal is...
  5. R

    VBA for Emailing multiple worksheets to individual recipient lists

    Hello, First time poster here. I have a workbook with a Macro (created by someone that's no longer with the business) that emails each worksheet (approx 30) to a recipient list in each worksheet. It basically copies and pastes each sheet into a new workbook, saves the file into a temp...
  6. J

    Macro to send worksheet to Outlook email

    Hi, I am not too familiar with macros. Is it possible to create a macro that will send a worksheet as an attachment to an Outlook email? I would like to create a "Submit" button at the bottom of my worksheet that will send the email if possible. Also, is it possible to have a dialogue box open...
  7. U

    VBA - Excel Worksheet Selected Range to PDF - Email via Outlook

    Dear Forumers, I am very new to the concept of VBA. I have a workbook with an identical template in each sheet. Each sheet represents different areas of the business. What I want to do is, when I have all the information in these sheets, I want to send the selection of the print area as a PDF...
  8. L

    VBA Finding file in directory with LARGEST file size.

    Hiya all, I've got everything working for this Macro except for one piece to this puzzle. I'm in the process of trying create an Email Attachment system that loads the "Signature" from Outlook. Our company uses multiple signatures for various types of emails (Default email Sig, Vendor sig...
  9. J

    e-signature dialogue box?

    Hi All, I have been putting together some VBA to do a mail merge with attachments which is all so far so good - my next thought was to maybe have a sign off button within the email which when pressed a popup will appear asking for a signature which they can do with the mouse. At the moment I...
  10. I

    Hidden Columns Appearing on Smart Phones

    Hello Everyone! OK, I'm stumped. I have been generating and emailing password protected spreadsheets for years, hiding rows and columns that I don't necessarily want shared with everyone, with no trouble at all. Then all of a sudden, a few months ago I get word that hidden columns on one of my...
  11. F

    Need help in Macro for 2 tasks

    Good day all! First, I must admit that this website has helped me in many instances for my no-vice coding skills. Now, I am in a fix. I am sincerely looking out for help from fellow members in performing the following tasks. 1. Copy a range of cells from active sheet and put that in body of...
  12. M

    Help modify macro to send 1 email to multiple recipients listed on active sheet

    I found this macro code VBA code to convert excel to pdf and email it as attachment that PDFs an excel sheet, attaches it to an email and sends it out. And it works great. I'm looking for one modification. I want my recipient list to be of email addresses in range B46:B60 that are on a sheet...
  13. C

    Creating and Mailing a PDF From Excel (Using Outlook)

    Hey guys, So I have spread sheet with a Data Input Tab and once the info is in there I created a button to export it as a PDF & Save the document as an Excel file on my desktop. I have posted the code below and was curious how to add on or make a separate button to export the PDF as an email...

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