PC Review


Reply
Thread Tools Rate Thread

auto e-mail to numerous people

 
 
=?Utf-8?B?Sk9VSU9VSQ==?=
Guest
Posts: n/a
 
      17th Oct 2006
I'm using this code in an exisitng macro to auto send the workbook to
(E-Mail Removed), however when I add additional e-mail addresses as shown
below, it won't work, any idea what I'm doing wrong?

ActiveWorkbook.SendMail "(E-Mail Removed)"; "(E-Mail Removed)";
"(E-Mail Removed), "Today's Report"
 
Reply With Quote
 
 
 
 
Franck
Guest
Posts: n/a
 
      17th Oct 2006
I was typing the code but easier to post the link and it save space on
google servers

http://j-walk.com/ss/excel/tips/tip86.htm


JOUIOUI a écrit :

> I'm using this code in an exisitng macro to auto send the workbook to
> (E-Mail Removed), however when I add additional e-mail addresses as shown
> below, it won't work, any idea what I'm doing wrong?
>
> ActiveWorkbook.SendMail "(E-Mail Removed)"; "(E-Mail Removed)";
> "(E-Mail Removed), "Today's Report"


 
Reply With Quote
 
Ron de Bruin
Guest
Posts: n/a
 
      17th Oct 2006
Have you change the loop numbers
For r = 2 To 4 'data in rows 2-4

You can also use this example based on John's example
http://www.rondebruin.nl/mail/oebody.htm

Example 3 on that page


--
Regards Ron de Bruin
http://www.rondebruin.nl



"Franck" <(E-Mail Removed)> wrote in message news:(E-Mail Removed)...
I was typing the code but easier to post the link and it save space on
google servers

http://j-walk.com/ss/excel/tips/tip86.htm


JOUIOUI a écrit :

> I'm using this code in an exisitng macro to auto send the workbook to
> (E-Mail Removed), however when I add additional e-mail addresses as shown
> below, it won't work, any idea what I'm doing wrong?
>
> ActiveWorkbook.SendMail "(E-Mail Removed)"; "(E-Mail Removed)";
> "(E-Mail Removed), "Today's Report"



 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Emails Being Downloaded from Mail Server Numerous Times Jeff Microsoft Outlook Discussion 6 30th May 2008 08:43 PM
Numerous accounts for Windows Mail Jerry Windows Vista Mail 2 24th May 2008 02:03 AM
auto e-mail to specific group of people their own info? =?Utf-8?B?c2FnaGll?= Microsoft Access Macros 0 20th Nov 2007 03:16 PM
How to view numerous photo attached to an E-mail (Outlook 2007)? =?Utf-8?B?ZHN0dWJi?= Microsoft Outlook Discussion 2 23rd Jun 2007 05:30 PM
How can I send the same letter to numerous people without having . =?Utf-8?B?c2Npc25lcm96?= Microsoft Word Document Management 1 18th Nov 2004 02:41 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 05:57 PM.