Browse by Tags

Send email through excel vba to multiple recepients through sendmail method

Hi I am using Excel 2000 I need to send a file throgh excel vba to multiple people The number of people is unknown and the list of emails comes in a string like " r_brown@ibm.com; s_martin@ibm.com, d_patel@ibm.com...... " how can i send this using the sendmail fucntion Earlier I had only one...

Posted to Excel (Forum) by microsoft on 02-26-2010
Excel template open with email headers

I have a template which I use for an Excel workbook. When the template is opened it has the email fields at the top ie To:, From:, BCC:,Subject:,Introduction: How can I make these go away fo that the templateand workbooks created from it appear as 'normal' workbooks?

Posted to Excel (Forum) by microsoft on 01-20-2010
Excel VBA email - Outlook dialog box pop asking permission

I have many Excel 2003 & 2007 Visual Basic apps that I curently send email from within the code. THe Excel auto starts every morning at a specific time reads data from ODBCs creates the results and then emails and then shuts down. The problem: when it issues the email Outlook pops a dialog box saying...

Posted to Other (Forum) by microsoft on 01-13-2010
Send Email from excel when cell value equals 'x'

Is it possible to have excel send and email when a cell = a certain value? I have a worksheet accessed by our field engineer for spares, when his stock level reaches a certain value I would it to email our stock controller to alert her to the fact. Is this possible?

Posted to Excel (Forum) by microsoft on 08-16-2009
Email Selected Excel Sheets - Not Whole Workbook

I know this solution is likely available as an answered question, but I cannot seem to navigate the site right now. CS is working on it, but I am willing to spend points for a custom answer. I am looking for code to email selected Excel sheets (not the entire workbook) through Outlook and/or Outlook...

Posted to Excel (Forum) by microsoft on 08-13-2009
Excel/VBA Email address validation

I need to perform limited validation of email address that will be entered into cells on a spread sheet. I want to make sure the address: 1 Contains exactly 1 @ sign. 2 There are at least 2 letters before the @ sign 3 There are as least 3 letters after the @ sign and prior to the domain name...

Posted to Excel (Forum) by microsoft on 08-06-2009
Excel VBA automatic Outlook email creation

I have the macro working exactly as I want, almost. The only pain left is the message below. A program is trying to automatically send e-mail on your behalf... then it gives you the option to click yes or no.... Is it possible to overcome... this option....? And not have it show up? The other part I...

Posted to Microsoft Office (Forum) by microsoft on 07-13-2009
VBA code to paste Excel table into email & sending email

Hi, I have an admittedly really unusual question: I have an excel table thats updated automatically, and one colum of the email contains email addresses... Now, I am looking for a VBA code that: - loops through each row of the table - Pastes the content of each row into email - pastes the correponding...

Posted to Excel (Forum) by microsoft on 07-10-2009
Macro-Sending Excel Worksheets via E-mail

I have been working on a project. For this project I have added a button to an excel spreadsheet so it can take the worksheet, copy it to a new workbook, save it as a file, open the e-mail editor, and then delete the file. I have looked around and my personal favorite was here, http://excel.tips.net...

Posted to Excel (Forum) by microsoft on 07-06-2009
How do i copy email addresses over from excel to MS Outlook ???

Hi, I have an excel spreadsheet 2007 with about 100 email addresses on. Nothing detailed just the email address. I have been trying to figure out how to import these into Outlook 2007 so that i don't have to manually type these in. this is how i've been doing it. In excel highlight the 100 email...

Posted to Outlook (Forum) by microsoft on 06-26-2009

Page 1 of 2 (13 items) 1 2 Next >