outlookmail

As the title suggest, I'm trying to export Undelivered emails in Outlook to Excel (sheet1) I found this code on the web, and I'm having a little difficulty getting it to work Ideally I would like the data to appear in columns, a separate column for Email address etc The Emails are in sub-folder...

I have 2 shared mailboxes where I retrieve the count of the mails. These 2 shared mailboxes have 2 different mailaddresses. When I combine these 2 codes, it gives the following error: <code style="margin: 0px; padding: 0px; border: 0px; font-style: inherit; font-variant: inherit; font-weight...

Happy Friday, I have a sheet to send monthly and I want to create a button and a code to send it to the same people every month. The button works but the code isn't EXACTLY how I want it. Here are my issues: 1) My signature is not showing up 2) I can't get the font to be Arial, 11. Sub...

Hello, I have a macro that automatically sends an email with a copy of the workbook as an attachment. I recently made a slight change to add an extra cell value on to the name of the attachment and since then a number of users when they send the email have additional system file attachments on...

Hi all, I was able to create a macro that allows me, with the push of a button, to send he Excel file to a certain address. Sub Mod_SendWorkbook() Dim OutlookApp As Object Dim OutlookMail As Object Set OutlookApp = CreateObject("Outlook.Application") Set OutlookMail = OutlookApp.CreateItem(0)...

Hi All I want to import mails from my outlook inbox to excel sheet depending on subject line i.e. if and only if subject line contains text APPROVED or CLARIFICATION at the start of subject. Subject : APPROVED xyzz..... CLARIFICATION abc..... only this type of mail need to be...

I have this VBA to auto generate an email upon completion of a form and a submit button, however, due to consistent issues with their information I need to add the ability to not create the email and attach the form if the text boxes are not filled out. Does anyone know of a means to do that by...

Hello, I'm new in Excel VBA and I'm trying to get only the Outlook's latest email body,sender, and subject and copy it to excel but my code is getting all the emails from today. Sub GetDataFromOutlook() Dim Outlook As Outlook.Application Dim OutlookNamespace As Namespace Dim Folder As...

my goal with this code is to save my file to PDF and as XLSM file to my pc, then after that it gets put in an automated email where the PDF and XLSM file are attachments. My Problem: since I am just a beginner when it comes to VBA, I dont know what I am doing wrong.. Could you guys tell me...

This code is supposed to save the file as PDF to my pc and after that mail the XLSM and PDF file as attachments in an automated mail... but my pdf's dont get saved properly because my code is wrong and I just dont know how to fix it, does anyone know how I can fix it? Sub saveandsend() Dim...

At the moment my code works like this: when you click on play it automatically saves the file to PDF, then it opens the mail itself with a title, etc and also with a XLSM file. now I want it to add the same file as PDF instead of XLSM.. how do I do that if the title of the PDF is the cellname...

I want to send the worksheet what im working on as PDF in outlook by using VBA, when I test this out it does make an attachment but the PDF file is broken and wont open.. anyone know how to fix this? Sub saveandsend() Dim Path As String Dim filename As String Path = "DIRECTORY" filename =...

Hi! I'm looking for a way ensure that no other cell can be populated within a workbook until the "TODAY DATE" cell is populated, which is cell "AE2" on the worksheet. I'd like to insert the code above my existing VBA. Sub SendWorkBook() 'Created by 20181018 Dim mystr As String Dim OutlookApp...

I've implemented the below VBA to use to send the form that it is for to a specifc emai address, but would like the VBA to populate the "SUBJECT LINE" of the email it generates with a concatenated cell from the workbook. The cell is identified as AM11. Is this even possible? Sub SendWorkBook()...

I am having a problem trying to retrieve from mail from Outlook into Excel via VBA. I used the following code (the names of the shared folders are obviously not the real names), and it retrieves all of the mail, but only the first line of the body of the email rather than the entire message. Can...

I am wanting to see if there is a way to change the name of the attached PDF. In the code below it chooses the FileName = wB.FullName. I want to customize the name of the file to be [ Range("LearnerLFName").Value + "-" + Range("CourseName").Value + "-Weekly Report" ]. I have tried: FileName...

Have been searching for hours and can't find anything to answer this... I have a worksheet that users will insert pictures (jpeg, gif etc.) as visual aids. What I would like is a way to extract all of the object images present on the worksheet and insert them as attachments in an Outlook email...

Hi there, I've a simple email script as follows: Sub Mail() Dim outlookApp As Outlook.Application Set outlookApp = CreateObject("Outlook.Application") Dim outlookMail As Outlook.MailItem Set outlookMail = outlookApp.CreateItem(outlookMailItem) With outlookMail .To =...

Upgraded to Excel 2016 / Outlook 2016 today and it broke my excel app. One of the functions I have created with the Excel app is to take the current sheet, convert to pdf then attach to Outlook email and .send. The PDF file is being generated and is appearing on the desktop. The code I am using...

I have been using the below code for sending an Email from Excel for many years on Windows 7, having now moved to Windows 10 if i chose to display the email and there is an attachment i am unable to click the send button as it is masked by duplicated, but blank, To: CC: and Subject boxes. With...