attachment email

Hi! I have a macro that fetches a file from an email in Outlook every day, and then runs a number of other vba codes on it. The macro runs great, but only gets the file from "today" and if there is multiple emails it only collects the oldest one. As a workaround, I sometimes have to email...

Hello, I'm in the process of moving files from a local server to SharePoint/Office 365. I have a Macro that creates a folder on the local drive then saves individual files created from a mail merge in Word to that folder and a second Macro that pulls those files into individual emails...

Hi, I have VBA code that I got from online, it sends email out to several recipients with each their own text if necessary. Now i would like to add an attachment unique to each recipient. In my code i see that it already has an attachment listed, but it does not work, when i sent out a test...

Hi, I need a macro that will save attachments that are sent by mail as a specific name. Let's say that the mail header is "incoming file - 2021-03-08". and that this mail has an attachment I want to save as "incoming File.xlsx" The next day another mail will come with the title "incoming file...

Hi everyone, As a new VBA learner, I am seeking for your help to solve these three problems when automatically send Outlook email from Excel. The code is now lacking these improvements. Your support would be highly appreciated. 1. Attach multiple files with file paths by criteria (For same...

Hi, I'm trying to put piece of VBA code together to attach some PDF files in outlook and send out. However, I sometimes work from my personal laptop and my business laptop. How can I code something like this .Attachments.Add "C:\Users\arazaq\Documents\Black\PDF Reports\Demo PDF\UK FTSE 100...

Hello, I have the following code that I use to send emails with specific sheets as attachments. It works fine but I need now to send sometimes multiple attachments. I can see that there are some topics about this, but I'm struggling to fit some answers on my code. Is there a way to make this...

Hi, been stuck on this one issue for some time. I have below code that attaches files based on B5 cells down with "REVISED" on it. It pulls all the files needed in one email except when "REVISED" file is not there. Where in the code do I need to place IF and below in red to pull file without...

I'm trying to automatically add a specific file to an email generated by excel. Everything works other than the actual attachment being added to the email. Does anyone see the issue? I'm using the following on excel 2013: Private Declare Function ShellExecute Lib "shell32.dll" _ Alias...

Thanks in advance for you help. Title says it all. I have an email I receive in outlook every day. It's called "Report 01/14/2016". The date changes daily. Within the email are two excel attachments. The one I need is called "Detail 0114". The date changes daily. I would like outlook...

I would like to have a script that takes the email address ex. "Fake_Name@example.com" & sets the attachment to "Fake_Name" then saves that file to a set folder. I am struggling with capturing the email address. Is this possible? Public Sub saveAttachtoDisk(itm As Outlook.MailItem) Dim objAtt...

Hello there! I have created a macro which will create a draft email and save it, with an attachment, in a specified folder. This has been looped in order to recreate this process a few hundered times if necessary. The macro works well with the first email however when it goes to attach the...

Hi guys I've created an excel macro that basically sends an email with an attachment included. I'm using gmail as mailsystem. Basically everything works fine, except for that fact that my attachment from first email generated will be included in my second email generated, both attachments from...

Hello all, I created a userform for Outlook that populates an email based on what the user chooses and enters in userform1. This works fine when I create a new email, but when I choose an Excel File or any type of file and send to mail recipient the combobox draws a blank in userform1. How do I...

Hello, I'd like to save incoming email attachments in Outlook using the name of the attachment, as the reference, to save it in the respective folder. What would be the easiest way to do this ? Many Thanks, Ian

Hi, I have to recognize that every time I work with arrays in the code drive me crazy at some point...and this is not the exception...basically I modified a code I found to create an email and attach an specific set to worksheets...and it worked, now I took the same and added a part in order to...