Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Microsoft Office > Excel VBA > Excel VBA
|
Excel VBA Discuss using VBA for Excel programming.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Excel VBA section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old August 5th, 2011, 02:15 PM
Registered User
 
Join Date: Aug 2011
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Default Request to provide VBA code for excel 2003 for sending mails with attachment

HI All,

We required to send mails with attachment to different people every month.

we are using "From" option in outlook to send mail from one common login id.


i have created a excel file with following details.

column A: Login ids for "From" field in outlook.
Column B : recipient names separated by comma for "To" field of outlook
Column c : recipient names separated by comma for "CC" field of outlook
Column D : recipient names separated by comma for "BCC" field of outlook
Column E : text for "subject" field of outlook
Column F : text for "BODY" of outlook mail
Column G : contain path and name of the files which needs to attach with mail , files would be in .Zip format and it can be one or group of files separated by commas


could you please help me to write code which use above excel database and sends mails and save the mail in sent folder of outlook?

Regards,
Dharmesh
 
Old August 5th, 2011, 10:11 PM
Friend of Wrox
 
Join Date: Sep 2005
Posts: 812
Thanks: 1
Thanked 53 Times in 49 Posts
Default

Here is a hint

http://vbadud.blogspot.com/2007/04/v...-vba-mail.html

Cheers
Shasur
__________________
C# Code Snippets (http://www.dotnetdud.blogspot.com)

VBA Tips & Tricks (http://www.vbadud.blogspot.com)
 
Old August 6th, 2011, 02:43 PM
Registered User
 
Join Date: Aug 2011
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Default

thanks for the link but the codes on the link shows static message.

but our requirements are different recipients in TO, CC , BCC , subject line and body of the mails as store in excel sheet.

also we need to attach specific files in .zip format with every mails so data should be taken from excel sheet.

could you please help with consideration of above requirements?


thanks for your support in advance





Similar Threads
Thread Thread Starter Forum Replies Last Post
#NAME? error running Excel 2003 VBA in Excel 2007 steveburn Excel VBA 0 October 24th, 2009 08:47 AM
Help! Conversion Excel 2003 VBA codes to Excel 2007 sunny76 BOOK: Excel 2007 VBA Programmer's Reference ISBN: 978-0-470-04643-2 0 August 13th, 2009 05:38 AM
sending mails with extended character + attachment austinf Pro Java 0 February 21st, 2007 01:54 AM
Excel 2003 VBA Function RollingWoodFarm Excel VBA 15 August 2nd, 2006 04:24 PM
can VBA script open n mails per attachment each sriramus Access VBA 0 February 20th, 2006 06:24 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.