1. K

    Pastespecial from excel to outlook using VBA

    Hi guys, I need some help in my vba code. I am trying to pastespecial a screenshot of my excel file into email. For some reason unknown, I always get an error message when I try to compile the code- compile error can't find project or library. Strange enough, when I change the code to paste...
  2. F

    Send multiple PDFs in a folder to email addresses within a sheet from one of your email accounts in outlook

    Hi there, I need to send multiple PDFs from payment folders to email addresses within an excel file. I have a macro set up to pdf all the individual sheets into PDFs, and I have a sheet set up with all the email addresses in column A and the destination path in column B. In addition to this...
  3. D

    VBA remove margin before bulletpoint/unordered list in email

    Hello! I am using VBA to send out emails containing a text body made up of bullet points with varying lengths (using the code from smozgur in this thread: Use VBA to enter a varying range of bullet points into body of email). Which creates a reference to the bullet list in the body text instead...
  4. H

    VBA Prompt to Send Email

    Hello all! We're currently using a spreadsheet to record and track training requests, and have a column (W) to note if a learning request form has been completed. I'd like to add a VBA to send an email if the cell in column W says "Yes" - Would also like a pop up box to prompt this ("Would you...
  5. P

    VBA Open Excel Sheet in email attachment daily

    Hey! There seem to be quite a few topics on this, but I don't know why I cant get it working, I don't seem to understand something. https://www.mrexcel.com/board/threads/open-only-excel-files-from-outlook-folder.1194964/#post-5829313...
  6. L

    Outlook VBA - if no mail found

    This code runs perfect in finding and retrieving emails from my local sync shared mailbox - except when it cannot find anything, it does nothing; whereas I want it to tell me nothing is found (rather than have blanks where data should have been). Note: some text have been edited/converted to...
  7. C

    Excel VBA for Outlook

    Hi All, I have a spreadsheet which works well but my leadership have asked to expand it's capabilities (If it's possible). Unfortunately I'm useless at VBA coding and had to seek help on the code I'm currently using. At the moment I have a text box which is transfered into the email body, but...
  8. D

    Adding images in table with formatting into Outlook using a file picker

    I have pieced together some code using excel as a file picker to add images to embed within subject body. Everything is working just fine with basic alignment, but I would like to get some help adding these images into a table with a specific formatting Outlook seems not to have a huge support...
  9. K

    VBA Mismatch error on calendar meetings

    Hello, I've followed a tutorial online to create meeting invites in Outlook from Excel. As far as I can tell, I've followed the tutorial exactly (besides changing the details to my spreadsheet). Currently, it's working. I run the macro and it creates all the meeting invites with the correct...
  10. C

    Bulk Emails with multiple variations

    Hi All, I have an idea of what I would like the spreadsheet to do however I have ZERO experience with VBA or coding and I've relied heavily on formulas in the past. I've created an example spreadsheet to try to explain what I'm trying to achieve but basically, I'm looking for a spreadsheet...
  11. Jyggalag

    Syntax error in mail body in vba?

    Hi all, I have the following code for HTMLBody: SendEmailTo.HTMLBody = "Dear all,<br/>" & "<BR>" & _ "bunch of insignificant text bunch of insignificant text bunch of insignificant text bunch of insignificant text bunch of insignificant text ""bunch of insignificant text"" bunch of...
  12. C

    VBA copy and paste data next blank row of a different worksheet each time macro runs

    Hello everyone, I am not an expert and need help please! I have a macro button [Get Outlook Data] on a worksheet that when clicked allows you to choose the folder in Outlook and then the data is shown on my worksheet 'Outlook Results'. Each time the macro runs it clears the previous data from...
  13. M

    Outlook/VBA - Extracting tables from all emails in a specific folder

    Hey all, I have come across a problem, and after scouring google and this website, I have come close, but still not quite where I want to be. For reference, I know almost nothing of VBA but I can somewhat follow the code logic, although its still not enough to come with a solution for my...
  14. E

    Tracking Outlook emails with Excel

    Hello Message Board. I’m a stock control manager & between myself & my team we send 000’s of orders per month & I need a quick & robust way of tracking what replies I’ve had for email order, or more importantly, when I’ve not had a reply at all, so I know when to chase for one. Is there a way...
  15. T

    How do I copy format (Italics / table borders / bold) from excel to outlook via VBA

    Hi everyone, Happy New Year! I've got the following code below however I can't seem to code it to copy and paste the tables / formats (as per header), only words get exported onto email outlook. Can someone help me to tweek it please? Super appreciate it! Code in question: Private Sub...
  16. R

    Outlook VBS - Automatically delay sending evening & weekend emails until 0700 the following weekday (script not quite right)

    Hi all, I've got a script for Outlook that *should* delay sending emails Mon-Fri after 1800, and any time at the weekend, until 0700 the next weekday morning. It seems to work Mon-Thu, but Fri-Sat it just sends it the following morning rather than waiting until Monday morning. Can anyone help...
  17. P

    VBA to export outlook email (individual email) to excel file with userinputs

    Hi All, Its been a while and I was hoping to learn more of VBA Coding. So here I'm with a request for VBA code to export outlook email (individual) to an existing excel file. So here is what I'm wanting the code to do: When I open an email in Outlook and press a hotkey (in groupmail inbox)...
  18. S

    Copy and Paste content from Excel to outlook .msg file

    Hi all, I have excel template where data are updated, once the data is updated i would like to copy the contents from each column and paste it in the table with blank column in the outlook .msg file which i have saved in my desktop currently, I have attached the screen shot of the excel sheet...
  19. 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...
  20. N

    Run Time Error 1004 PDF & Outlook

    Good morning incredible excel people! ? I hope you’re all going well this sunny weekend. I was just wondering if someone might be able to help point me in the right direction or if you have any ideas that would be greatly appreciated. I have the below module that takes two sheets and inserts...
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

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