outlook

The Macro below is currently set up to create individual invoices and save as PDF's based on a database sheet with invoice data on each row and then an invoice template on another sheet. The macro loops through each row in the database and changes a number on the template with each iteration...

Hi there, I'm looking for some help with drafting an email to Outlook from excel. The Image below shows a typical sheet information. Each column has different data which is needed in one of the email fields. I would like to be able to press a button and have a draft email appear to the...

Hello, I have the below code in Excel that generates emails. I'd like to add a hyperlink to a website in the middle of the email body but can't work out how? Does anyone know? Sub SendEmails() Dim Emails, Subject, FName, SName, Attachment, Body As String Dim i As Long Dim OutApp As Object...

Hi, I would like to optimise my excel spreadsheet Is there a scrips to in one Column according to the name selected from a drop down box an email would automatically be generated and sent to the relevant persons after saving the document (data changed, email trigger to the selected individuals)...

Trying to exclude sender when recipients hit Reply All, in Excel generated Outlook email. I have: EmailItem.To = "email2@email.com" EmailItem.CC = "email3@email.com" I think I can do: EmailItem.ReplyRecipients.Add "email2@email.com; email3@email.com" But how do I do that without...

I have a VBA script in Excel that is combing my inbox in outlook for emails with specific subject line text and then it does stuff. The issue is that for whatever reason it's skipping the first 5 days of emails and jumps straight to 7/6/2022 and then goes one email at a time with the receipt...

Scenario: Another user on Microsoft Exchange has shared an Outlook Contact folder with me and I would like to create an Excel VBA macro to copy the content of that folder to another "local" folder in my Outlook Contacts. I have written a VBA solution that is very close to what I want but it...

I am wondering I have one module with 95%+ of the code for my macro in different subs. what is the cleanest way to do this? Each sub in its own module? also is it better to put all the code that is for just that sheet in a module attached to a sheet? Or other ideas that may help? all my code is...

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

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

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

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

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

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

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

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

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

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

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

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