send

Hi Guys I have a file where it has various combo boxes with info. I would want a code to send an email with the info in the subject line and in the body of the mail File loaded here http://s000.tinyupload.com/?file_id=43617830343183525506 Regards CT

Greetings everyone, Can someone please help me with the following: I have a long list of e-mail addresses in Excel that I want to send emails to. I want to send the emails individually so that I can track who/when the emails are opened. I want to use Outlook, because I have made templates of the...

Hi I am looking for code to allow me to send and email using Outlook based on data in an excel spreadsheet. NOTE - I am using Excel for MAC (I Believe That This Complicates Things). Basically... Cell A1 Will Contain The Email Address Cell B1 Will Contain The Location Of A File Which Needs...

Hello, I have one big excel file with for example 100 rows and 10 colums. I want to break this file into multiple files based on the contents of a single column and then send email to separate persons. For exemplification, in the following table I want to split into multiple small table...

Hello: I have figured out how to send a gmail or outlook email, adding spreadsheet ranges to the email body, and adding file attachments to the email using vba within excel. The one thing that I cannot figure out (and have searched extensively), is how to create a gmail draft and not send it...

Hello Guys I have a piece of code that will look at a cell (M) and if the value of the cell is = (yes) then it will take the e-mails stored in cell (I) and the name of the client stored in cell (G) and the it will send the e-mail when i run the code. Ok so where im heading is if someone could...

Hello Everybody i am quite a novice I need help to automatically record inventory as per invoice (outgoing) & as per purchase order (incoming) I have sample sheet which I can send you but I can’t see how to attach it here Here is a link to the sample file...

Below is a snippet of the code I use to send emails from excel. I would like to expand this to change the sent from based on a list of vendors. So What I think is as the email is generating it would compare the field "VND" which is the vendors name against an excel spreadsheet and change the...

dear Gents , I have a query if their is any one can help me , i have an excel file separated to sheets depend on the manager name each sheet contain information for employees these employees , in the informations i have the email for the manager my question how i can send email to the...

Dear Sir I am using following code and it copying my file It is copying my file to current folder where original file exist, I just need on amendment to send this file to a folder name PDF, if folder not exist then VB need to create it Thisworkbook.path/PDF

Hi all I have a training spreadsheet and want to send an automatic email to a manager when a cell D9 changes to "Retrain" in the column D "Status" Cell C9 holds the managers email address manager@email.com I need the following in the email: email address of the recipient Subject: Training...

Hi 1. How to send an email from an Excel sheet on a Mac computer? 2. How to send a SMS from an Excel sheet on a Mac computer? 3. How to send a SMS from an Excel sheet on a Windows computer? Wish you all a great new year from Denmark

Hi I currently send invoices via email using excel. I use gmail and the process works extremely well. My question is - can I use a similar logic to send text messages? For the email process I reference CDO - is there something similar but for texting from a range of telephone numbers? Many...

Hi all , have a small workbook created as a working time card which i want to send by e-mail. So far so good .... but would like to send it only the selected worksheet and not the whole workbook, and if possible only the print area without formulas, shortcuts and macros. With this code I get...

I have a workbook that has 7 sheets. I am looking for a method to send each sheet to a different location with one button. Only if there is data on the sheet. Example Sheets1-2-3-4 have data in a given range and 5-6-7 do not have any data in that same range sheets 1-2-3-4 will be sent to their...

Hey guys and gals, hope your all having a great Sunday. I have a phone call log with entries from column A to N (Sheet name 2018 Call Log) Column M has the e-mail address i need to send the e-mail to Column N has a drop down box to select Sent The data i need to send is Column A to K and send in...

Hey guys, I have a macro that's been working perfectly for years which would create an email for each invoice on each separate sheet, to an email address listed in a cell on each page, while at the same time creating a pdf of the individual excel page and attaching it to the email. The emails...

I have this macro that email's a specific range from an actvive sheet that works perfectly until I try to add an attachment from a file path on my computer and this is where I get the 438 error. What am I doing wrong? Any help is greatly appreciated. Sub Email_Test() MsgBox "Email will be...

HI, I have the data in google Excel sheet. How to send auto generated gmail from that excel cell contents Need to send status report on daily basics Eg: To:Distro to be sent Subject: Status report Body Content: All, Please find the status report Table format to be displayed from that...

with VBA how to send email with an atachment? thanks