attach

Hello Everyone, i am trying to send emails to recipients with attachments but one recipient has multiple records and will have multiple attachments and i want macro to send just one mail consolidating all the rows and attachments. So far, the macro is able to send single email for every row. i...

Hi Everyone, I am trying to create a tool for an email marketing campaign. I was able to make codes that will send an email to a distro based on the customer type with an opt in option. Everything was working fine until my boss asked to add objects depending on the email campaign that has...

Hi all, i need to attach a file in a outlook from my local path wherein the path keeps changing in a daily basis however it would be better for me if i do a changes in a cell reference instead of directly in the macro. below is the syntax which i directly keep changing the path in the macro...

Hi out there! I would like to provide a search function, based on two values. If it was a sum, I would be fine, as I would use sumproduct, however I am trying to return multiple results which are not sums. I would like to attach a sheet - this would be the easiest way of explaining how to do...

I need macro code that send my excel sheet to multiple email recipients and attach a screen shot of the dashboard on message body

Working with Index Match for the first time; keeps returning an error #N/A. =INDEX(DATA!A2:G102,MATCH(DATA!A2:A102,0),COLUMN(DATA!A1)) I'm using MS Excel for Mac 2016. Is there a way to attach the file to this thread?

I have a code using CDO.message in VBA to send email from excel through Gmail. I can successfully send emails and also attach different files. BUT! 1. I want to be able see/edit email before sending it! If i am not mistaken ".display" does not work for CDO.message. Any other way to get around...

Hello Everyone, I am trying to create a macro that will pull all the data from 80+ files into one sheet. In each of these 80 files they have individual names (ex: Upload_ABC, Upload_DEF,...) The date is in the 3rd tab of each sheet from A:T. I need a macro where I can put in the individual...

Hello, I am trying to attach a PDF version of an excel spreadsheet form I have as well as the spreadsheet itself but I cant seem to figure out the VBA code that will attach both types of files. I have been successful in attaching the PDF but I cant seem to figure out how to get the spreadsheet...

Hi, I have the code below triggered in an excel workbook to open gmail, attach a file and send it to the specified address. When I run the code; the attaching of the file doesn't work. It finds the correct file but wont click "Open" to attach it. <johnpowell@effectphotonics.nl>Sub...

I have spreadsheet with a column (N14:N68) of numbers and blanks. I want to use the last value in the column. =LOOKUP(2,1/(N14:N68<>""),N14:N68) This returns a blank answer. I can attach a spreadsheet example with this post, but I don't see how that is possible? Thanks!! Mike

Hi guys! I am trying to figure out how to attach a pdf file into my excel worksheet as a reference but i am afraid i have no more ideas as everything i tried failed... I have a workbook to issue invoices and i would like to attach the corresponding pdf file of the invoice next to the data in my...

<tbody> NAME (A1) EMAIL (B1) SUBJECT (C1) TEXT (D1) ATTACHMENT (E1) Andy (A2) ah@mail.com Auto email Dear (insert name) Andy This is a sample of the body text to be included in the email message. Signature Attach PDF 1 Harry hj@mail.com Auto email Dear (insert name) Harry This...

please help, I was trying to attach the error I encountered while accessing my excel file but I cannot find the icon for the attach file. I cannot edit my excel file and cant even open a new one it says product activation failed. what does it mean. thanks

Hi guys I am trying to make an outlook email button that when pressed it will attach an already attached file (object) that's on a cell in the worksheet into the body of the email. Hope this makes sense to you guys thanks

Hi, I have an extremely tight deadline (Monday) to create a spreadsheet with 2 sheets, 1 tab with have the twitter constants and the second tab will have a button that will post what ever is in "A1" to the given twitter account from the constants on the first tab. Does anyone have something...

Hello experts, The scenario I am working on is the following: I receive an email with a pdf invoice from a supplier; I register the invoice in an excel file; If the invoice is ok, I send an email to the accountants, with the invoice attached, saying it is approved. What I would like to do...

FAQS state "To attach a file to a new post, simply click the [Manage Attachments] button at the bottom of the post composition page, and locate the file that you want to attach from your local hard drive. I don't find [Manage Attachments] button. Is there something I need to do to be able to...

hi ALL I WOULD LIKE TO ATTACH A SPREADSHEET I CANNOT FIND THE OPTION ANYWHERE THANKS IN ADVANCE AC

I am working on having a sheet allow you to select PDF files from your computer and attach those files to the sheet and then send off the sheet. It does attach however when sending the file out to someone else the file is lost because that file remains on that local computer. Below is the code I...