attachment

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

Hi y'all , I have a tricky issue here ; I'm working on a code that would send an email to a list of clients with attachment that are related to these people. The Files (Attachments) are saved via a maccros that uses the name of the client in Sheet 2 Col A to integrate their names in the...

I want to be able to open multiple emails one at a time from the same sender with similar subjects, open the attached .csv file, then move that tab to the original workbook, close the email then process the next one. The emails come from MyAlerts with "Product Structure for XXXXXXXXXX" in the...

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

Hi everyone From part of an Excel VBA codebase, I'm failing to automate alignment of just one shape in a PPT presentation. This seems to be because Align is for ShapeRange rather than for Shape. In code below, VBA identifies vPic as the active shape ; that's why the SendToBack command works...

Dear all, I am using Macro in Excel to automate all the tasks I do in a day. I need you help. I am using Excel to check daily inventory. At the moment, I have to copy & paste the stock data which is in *.txt format into excel sheet, then pivottable, format bla bla bla... The stock data will...

<tbody> A B C D E 1 Name Primary Email CC File 1 File 2 2 John emailohn pathway pathway2 3 Jane emailjane email1;email2 pathway </tbody> Hello, I am trying to create a macro that will send individual emails (with specific CC's associated) PDF files, sometimes multiple files. I...

Good day all from a sunny South Africa I have a VBA code that work fine 99% It creates an email Add an attachment Personalise the email Have a distribution list Use a default body created in advance Can set a time delay between emails etc. The only problem The first email adds the attachment...

Hi all, I have tried to learn just enough VBA to get a simple task done, and I'm stuck. Your guidance would be appreciated. This basic code I copied and manipulated from Youtube... I am setting this up in attempts to populate emails, each with a unique recipient, subject line, message, and...

Hello! I'm currently trying to rename a file and then attach to outlook email but I'm facing an problem. On the way that I need, I have two diffent cells, one that contains the old file name and another cell that contains the new name. About renaming files everything is ok, the problem is...

Hello. Is there any way to programatically (by VBA) add an attachment to an invitation meeting in Lotus Notes? A lot of google-ing did not clearly reveal the method. Below is my code which blocks at line '*** Call objNotesRichTextItem.EmbedObject(1454, "", Attachment1, "") *** Sub...

Dear Mr. Excel, First of all I wish to thank you for uploading loads of interesting videos on Youtube which certainly help a lot, absolutely generous of you :) I hope the following will not be much of an issue for you and you would be able to help me at the earliest I am trying to create a...

I currently have a spreadsheet setup on a Macro to send & distribute a message from an 2007 Excel file to multiple users through Microsoft Outlook 2007. It is currently setup to send as an attachment. I need to find a way to have this file be sent as a PDF file. I know you can save Excel as...

I would like some pretty straight forward code to send an email with an attachment. I currently can use the ActiveWorkbook.SendMail code with an array for all my email address, but it does not allow you to CC anyone or the text you want for the body. I have tried several different suggestions...

I stole the following off of another post. I've added just a bit more, but I need to get it to attach a file that I would like to spell out in the call statement if at all possible. I cannot find the correct wording. :confused: Thanks! Laura Call SendEMail(Array("Laura.Ford@fotlinc.com"...

Hi, Im fairly new to VB and wondered if anyone can. I have created a script and a rule in Outlook, that will automatically pull attachments into a specific folder on my desktop. I have managed to tweak the code so it only pulls PDF & TIF files, and will place a number in front of the file name...

I couldn't find anything on this. I have about 20 reports emailed to me throughout the night. Each come in separate emails and go to a designated folder based on mail rules I have set up in LN. Each day, I have to go into each email and save the reports to my hard drive. Then go through and...

Hello All, I have record macro but have a problem in sending the email. My Macro did open Microsoft outlook. But I must write down the email address one by one. Iwant to send this email to example1@nothing.com, example2@nothing.com etc. Does anyone can help me to finish it? Sub TEST4()...

Hi, The following code will send an email to the MailAdd listed in range("L9"), using the file name created strPath & strFile which is listed in range ("M9") I would like to loop and send an email to each of the MailAdd in range ("L9:L25"), using the file names in range("M9:M25") Is this...

Hi I have seen some VBA code for saving attachments into a folder from incoming emails. Could anybody guide me to do this one attachment at a time ? I should be able to trigger a macro which should save the attachment in the "open" email as I am reading it - into a folder I have already created...