Hello Friends,
It's really gr8 and useful. Thnxs Ashish.
Anyone can help me, if I want to send a single msg/mail to more than
one person through excel, how can i do this. I mean i want to mark
more than one person in "To" and more than one person under "Cc"
category. Is it possible through Excel, if yes, how?
-
Manish
On Dec 16, 4:30 pm, ashish koul <koul.ash...@gmail.com> wrote:
> hi
>
> check the attchment
>
> i made it for my own purpose it send the email to all the email ids
> mentioned in col b
>
> with different attachmnet as in col e and col f
>
> you can romve the attchment option and can also add more attchament
> options
>
> rember attachment cols e and f and col b can not be blank
>
> and you can amend the code as per your requirement
>
> Thanks
>
> On Tue, Dec 15, 2009 at 11:17 PM, Hiren Sheth <hiren.sh...@viteos.com>wrote:
>
>
>
> > Hi,
>
> > I have just started VB programming. I have gone through your query & I
> > think if you change the code to .To = Sheets("Email").Range("A2").Value then
> > mail will be sent to e-mail ID mention in cell A2. I do not know how to send
> > mail if you have more than one emial addrees. But I think this may help you.
>
> > Regards
> > Hiren
>
> > -----Original Message-----
> > From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com]
> > On Behalf Of JMac
> > Sent: Tuesday, December 15, 2009 8:21 PM
> > To: MS EXCEL AND VBA MACROS
> > Subject: $$Excel-Macros$$ Send Email from Excel to Multiple Addresses
>
> > I have a excel 2003 file that contains the following code to send a
> > email message to several people.
>
> > Sub SendMail()
>
> > Dim OL As Object, MailSendItem As Object
>
> > Set OL = CreateObject("Outlook.Application")
> > Set MailSendItem = OL.CreateItem(olMailItem)
>
> > With MailSendItem
> > .Subject = "Test"
> > .Body = "Testing 1,2,3"
> > .To = "b...@bob.com; s...@sam.com"
> > .Send
> > End With
>
> > End Sub
>
> > I would prefer to get the addresses from a list on another sheet
> > instead of typing each one in the above. I've tried the following,
> > .To = Sheets("Email").Range("List")
>
> > But I get an automation error when I run it.
>
> > Any suggestions ?
>
> > Thanks
>
> > --
>
> > ----------------------------------------------------------------------------------
> > Some important links for excel users:
> > 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at
> >http://www.excelitems.com
> > 2. Excel tutorials athttp://www.excel-macros.blogspot.com
> > 3. Learn VBA Macros athttp://www.vbamacros.blogspot.com
> > 4. Excel Tips and Tricks athttp://exceldailytip.blogspot.com
>
> > To post to this group, send email to excel-macros@googlegroups.com
> > If you find any spam message in the group, please send an email to:
> > Ayush Jain @ jainayus...@gmail.com or
> > Ashish Jain @ 26may.1...@gmail.com
> > <><><><><><><><><><><><><><><><><><><><><><>
> > HELP US GROW !!
>
> > We reach over 6,500 subscribers worldwide and receive many nice notes about
> > the learning and support from the group. Our goal is to have 10,000
> > subscribers by the end of 2009. Let friends and co-workers know they can
> > subscribe to group at
> >http://groups.google.com/group/excel-macros/subscribe
> > This message is for the named person's use only. It may contain
> > confidential, proprietary or legally privileged information. No
> > confidentiality or privilege is waived or lost by any mis-transmission. If
> > you receive this message in error, please immediately
> > delete it and all copies of it from your system, destroy any hard copies of
> > it and notify the sender. You must not, directly or
> > indirectly, use, disclose, distribute, print, or copy any part of this
> > message if you are not the intended recipient.
> > Viteos Capital Market Services Ltd.and any of its subsidiaries each reserve
> > the right to monitor all e-mail communications through
> > its networks. Any views expressed in this message are those of the
> > individual sender, except where the message states otherwise and
> > the sender is authorized to state them to be the views of any such entity
>
> > --
>
> > ----------------------------------------------------------------------------------
> > Some important links for excel users:
> > 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at
> >http://www.excelitems.com
> > 2. Excel tutorials athttp://www.excel-macros.blogspot.com
> > 3. Learn VBA Macros athttp://www.vbamacros.blogspot.com
> > 4. Excel Tips and Tricks athttp://exceldailytip.blogspot.com
>
> > To post to this group, send email to excel-macros@googlegroups.com
> > If you find any spam message in the group, please send an email to:
> > Ayush Jain @ jainayus...@gmail.com or
> > Ashish Jain @ 26may.1...@gmail.com
> > <><><><><><><><><><><><><><><><><><><><><><>
> > HELP US GROW !!
>
> > We reach over 6,500 subscribers worldwide and receive many nice notes about
> > the learning and support from the group. Our goal is to have 10,000
> > subscribers by the end of 2009. Let friends and co-workers know they can
> > subscribe to group at
> >http://groups.google.com/group/excel-macros/subscribe
>
>
>
> email macro.xlsm
> 24KViewDownload- Hide quoted text -
>
> - Show quoted text -
--
----------------------------------------------------------------------------------
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com
<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!
We reach over 6,500 subscribers worldwide and receive many nice notes about the
learning and support from the group. Our goal is to have 10,000 subscribers by
the end of 2009. Let friends and co-workers know they can subscribe to group at
http://groups.google.com/group/excel-macros/subscribe
