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 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
Extract email addresses from Outlook using VBA

I'm looking for a VBA approach to extracting all email addresses from the headers of all emails in all folders in Outlook. Output should be to a text file in some format, duplicates are okay. All email addresses should be in internet form (xxx@yyy.com), not just the friendly name that Outlook might...

Posted to Outlook (Forum) by microsoft on 10-02-2009
Create Outlook rule action to mark message header for download

I just don't have the time to look into this like I normally would to "learn" the solution on my own. I hope you experts can help and glad to have a question for you. :) I use Outlook 2007 on a computer. I have it set to only download headers and then I mark the messages I wanted to download...

Posted to Outlook (Forum) by microsoft on 09-17-2009
Outlook VBA - getting the TO email address ...

Hey folks, I'm in a crunch here. Observe exhibit A - Outlook code that's actually being run in an Access Module - but that doesn't really matter here: ******************************************** Public Sub MessageStuff() Dim myOlApp As Outlook.Application Dim myNameSpace As namespace Dim...

Posted to Outlook (Forum) by microsoft on 08-21-2009
Is there a way using VBA code to send out an email generated from my Access application and if the recipient selects REPLY, the email is sent to another individual ?

I am developing an Access application using Access as the front end and SQL Server as the back end database. Is there a way modify the following VBA code to generate an email FROM JANE.DOE@MT.COM and when the recipients receive the email, he/she hits REPLY and the To: is another individual ? (Send on...

Posted to Access (Forum) by microsoft on 08-08-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
Inserting a hyperlink in an email created with VBA

I am composing an email with the Outlook.Application object, and I would like to insert a hyperlink that displays with a shorter version of the actual link. This is for a local file on our network. The example would be \\server-name\share\folder\folder\folder\file, displayed as filename (this would be...

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
Email a PDF report in VBA code

Can anyone see where i am going wrong in this code? DoCmd.SendObject (acReport("rptShredReceipt1, acViewNormal, , LinkCriteria")), acFormatXLS, "someone@somewhere.org.uk", , , "Your Shredding Report", "Thanking you for choosing ARchive Services Data & Records Management...

Posted to Access Coding/Macros (Forum) by microsoft on 07-10-2009

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