#### Email Macro

Hi

I am a real newbie so please bear with me if this is a simple question.

I have worked out how to put an email macro into a spreadheet:

ActiveWorkbook.SendMail Recipients:="me@nonesuch.co.uk"

but I can't work out how to send it to more than one recipient!

Dave


 0
dave4987 (5)
7/1/2005 5:49:02 PM
excel 39879 articles. 2 followers.

2 Replies
669 Views

Similar Articles

[PageSpeed] 1

Hi Dave,

See Ron De Bruin's SendMail page at:

http://www.rondebruin.nl/sendmail.htm

---
Regards,
Norman

"Dave" <dave@nonsuch.com> wrote in message
news:Ow2WuUmfFHA.3788@tk2msftngp13.phx.gbl...
> Hi
>
> I am a real newbie so please bear with me if this is a simple question.
>
> I have worked out how to put an email macro into a spreadheet:
>
> ActiveWorkbook.SendMail Recipients:="me@nonesuch.co.uk"
>
> but I can't work out how to send it to more than one recipient!
>
>
> Dave
>


 0
normanjones (1047)
7/1/2005 6:39:21 PM
Thanks Norman

Norman Jones wrote:
> Hi Dave,
>
> See Ron De Bruin's SendMail page at:
>
>         http://www.rondebruin.nl/sendmail.htm
>
>
> ---
> Regards,
> Norman
>
>
>
> "Dave" <dave@nonsuch.com> wrote in message
> news:Ow2WuUmfFHA.3788@tk2msftngp13.phx.gbl...
>
>>Hi
>>
>>I am a real newbie so please bear with me if this is a simple question.
>>
>>I have worked out how to put an email macro into a spreadheet:
>>
>>ActiveWorkbook.SendMail Recipients:="me@nonesuch.co.uk"
>>
>>but I can't work out how to send it to more than one recipient!
>>
>>
>>Dave
>>
>
>
>


 0
dave4987 (5)
7/2/2005 7:24:08 AM

Similar Artilces:

HELP!! Viewing email images
I have just recently switched to using Outlook rather than Outlook Express as my email program. I now find that any image attachments (.jpg, .bmp etc.) I receive are not visible onscreen as they used to be in Outlook Express. I have to click on each attachment icon to view... It's annoying, especially if I get a series of pics...I have to manually ope each one... Does anyone know how to set Outlook so that it shows me these images onscreen??? Many Thanks, Darren. ...

I'm missing all past years emails in my hotmail account
For some reason i logged in into my hotmail account and noticed that all my past years are gone. I havent deleted anything. I'm missing emails from 2006 till 2009 all of them? Please help....what can i do? If the Hotmail account is set as your primary store, could it be that you have AutoArchive enabled? Tools-> Options-> tab Other-> button AutoArchive... -- Robert Sparnaaij [MVP-Outlook] Coauthor, Configuring Microsoft Outlook 2003 http://www.howto-outlook.com/ Outlook FAQ, HowTo, Downloads, Add-Ins and more http://www.msoutlook.info/ Real World Questions, Re...

When I try to open a link included in an email nothing happens? Hi, This problem can be caused by several different things. Do you receive an error message when you click on a hyperlink, or does nothing happen at all? Can you use hyperlinks in other programs, such as Word? Please have a look at the following Knowledge Base articles to see if these resolve your problem. 177054.KB.EN-US OLEXP: Internet Shortcuts in Outlook Express Do Not Start Web Browser You can access this article by clicking on the link below. http://support.microsoft.com/default.aspx?scid=KB;EN-US;177054 257464.K...

slow emails
We are using exchange 2000 sever. and we have one user on one machine that her emails take awhile to process, up to 3hrs possibly. She is running outlook 2002, with all updates as of 10/9/03. I have figured in the past that it was just the other servers the mail was going through that was slowing it down. But when she uses, another persons acount on another machine it runs fine. Is this and outlook/machine problem, a server problem, or a problem that is out of my hands? Or is there a problem at all? >-----Original Message----- >We are using exchange 2000 sever. and we ha...

Trouble sending emails #2
I am recieving emails, but every time I try to send one I get an error message saying, "The server does not support the required HTTP methods. Ther server responded 'Not Implemented'." I have no idea wht that means or what I need to change. Help! On Thu, 30 Dec 2004 15:05:06 -0800, Tina wrote: > I am recieving emails, but every time I try to send one I get an error > message saying, "The server does not support the required HTTP methods. Ther > server responded 'Not Implemented'." I have no idea wht that means or what I > need to change. ...

How to forward emails (unchanged) from one account to another
Assume I manage two different profiles and eMail accounts with my Outlook. How can I adjust in one of them that all arriving eMails should automatically be forwarded (unchanged !!) to the other account ? Sven "Sven Claasen" wrote: > Assume I manage two different profiles and eMail accounts with my Outlook. > > How can I adjust in one of them that all arriving eMails should automatically be forwarded (unchanged !!) > to the other account ? > > Sven > Automatically forward messages to another e-mail account - Outlook - Microsoft Office Online: http://of...

New emails with attachments not being delivered
When I send a NEW email with an attachment to my husband, it is NOT getting delivered, however, when I FORWARD an email with an attachment, it IS being delivered. I've tried sending different types of attachments (Word, JPG, Acrobat) and it doesn't seem to matter. None of them (as new messages) are delivered. I can send the same message to his home computer and it gets delivered, it's just his work Outlook that seems to be the problem. My email address is on his list of safe senders. He can receive emails with attachments from others, including his home compute...

How can I tell if an email I have sent has been opened?
As per subject. You can try using a Read Receipt but many users block the return of them "AT" <AT@discussions.microsoft.com> wrote in message news:616E8A17-880A-46F9-9E6D-041484DA54E1@microsoft.com... > As per subject. you pay for it: http://www.readnotify.com/ you can try it out for a short time...then you pay...but it's pretty much guaranteed to get you the results you want... "AT" <AT@discussions.microsoft.com> wrote in message news:616E8A17-880A-46F9-9E6D-041484DA54E1@microsoft.com... > As per subject. Request a read receipt. But- it...

email set up in publisher
I set up a newsletter and tried to email it, a setup wizard came up and I cancelled it. now I dont have the send button for emails. how do I get the wizard or send button back? Cassandra Cassandra wrote: > I set up a newsletter and tried to email it, a setup wizard came up and I > cancelled it. now I dont have the send button for emails. how do I get the > wizard or send button back? Cassandra Start either Outlook Express or Windows Mail (whichever you have); this should prompt you. You have to have Outlook Express, Outlook, or Windows Mail set as your default mail client to ...

How do I export my emails and folders from Outlook to Thunderbird
I'm trying to export my email from and all personal folders from Outlook to Thunderbird. Any help would be appreciated. Thanks, Sam ...

How to get a macro to do what i want?
I have designed a form in Excel and the data that is inputted i want to be able to save in a separate worksheet. The problem i am having is that eveytime i record the macro, it over writes the same row each time (if that makes sense). For example if i copied every cell in the form and paste them into the database Row 1, i then want the new piece of information inputted into the form to go into Row 2 and then Row 3 etc.... But it keeps going into Row 1, it wouldnt move down the rows. Hopefully this makes sense to someone and someone can give me some advise. Calculate the last row ...

multiple revieve of emails
I recieve multiple copys of emails in outlook. In some cases I get 100 copys of the exact same message, in other cases it is ok, then others many times Only one message on server Jim <anonymous@discussions.microsoft.com> wrote: > I recieve multiple copys of emails in outlook. In some > cases I get 100 copys of the exact same message, in other > cases it is ok, then others many times Only one message on > server Usually caused by 1) Send/receive interval too small or 2) server timeout value too small or 3) rules that don't contain the "stop processing more rules...

Delay receiving email
Hi, We use Exchange 2000 and Windows 2000. I have recently been expeirencing intermitent delays in receiving email from two seperate domains.The delays are usually 3 hours but sometimes even longer. In the header info the delay happens at the last hop before reaching our domain. I have checked the exchange logs as well as the logs on our gateway but they do not indicate any delay once we receive the email. I am not sure what else I should do. Any help would be appreciated. Thanks, Bryan ...

Macro to apply alternate grey/white shading to selected paragraphs
Dear Experts: I would like to do paragraph shading using grey shading alternately. Example: this is a sample text This is another sample text This is yet another sample text This may be the last paragraph acquiring grey shading This is the penultimate paragraph This is the last paragraph With these 6 paragraphs selected, I would like to run a macro which applies grey shading alternately to the selected paragraphs, i.e. grey/ white (no shading) alternately. Help is much appreciated. Thank you very much in advance. Regards, Andreas Use Dim oRng As Range For i = 2 T...

Insert Static Date as part of Macro
I've built a nice macro, but I want it to insert the date it is run in an empty cell within the macro's range. When working within a spreadsheet, Ctrl +; returns the system date, but I can't figure out how to put that command into a macro. The macro recorder editor shows that the system recognizes the entry as the current date, not a function that returns the current date. The now() or today() functions are both dynamic ... they change with the system date. That's not acceptable in this situation. I need to seen when the macro was run. Thanks for any help, Ralph di...

Macro Security, Password Recovery & VB Code execution
I have found that if I set my macro security to high, VB code within (non-trusted) excel sheets do not execute... a microsoft security feature that ostensibly prevents non- trusted users from running VB The questions I have are : Is there a way to guarantee VB macro-execution using digital certificates or what-have-you ? Is there a way to detect, either within excel (well, not possible, it seems) or from outside, that the combo of users macro-security settings and signature status of a perticular excel file, WILL prevent VB from executing, if the file is attempted to opened ? ...

cant send emails 02-14-10
I have tried everything you guys have suggested in the other posts, including uninstalling and reinstalling the mail software. I have two email accounts & neither will send. It had been working since Nov 09 and just suddenly stopped. I have windows 7 & windows live mail. Here is the error I keep getting: Your server has unexpectedly terminated the connection. Possible causes for this include server problems, network problems, or a long period of inactivity. This is the local server I use. Subject 'Fw: Fwd: xoxo' Server: 'smtp.acsalaska.net' Window...

Exchange 2K: Controlling incoming email formats....
Question... AFAIK (and correct me if I am wrong), Exchange natively only lets you control message formats for messages that are downloaded to POP\IMAP clients. For security reasons, I would like Exchange to convert all incoming\outgoing email from\to external domains, as well as INTRA-domain email , to plain text format. In other words, I do not want to see anymore html email on my server going in and out, just plain text. Is there a setting for this for Exchange to handle this natively? If not, what (if any) 3rd party solutions are out there for this? Thanks, George Here's the Re...

Not recieving emails...
I have established an email account with Windows email and linked my yahoo email account. I can send messages yet I do not recieve the test messages to my Windows Mail account they do go to my Yahoo account but not to my Windows Mail inbox. I do not know what to do. Looked for answers on Windows website but did not find what I was looking for can someone please help me. Also when I click on the Send/Recieve tab it has me log in to my email account and then does not take login. Yet the account works. I do not understand. Thanks Jim It is a Yahoo Plus account - right? You must...

Macros and Active X
My ctrl+c and ctrl+v shortcuts dont work unless I turn on my active forms bar to edit mode. Any guesses why -- Message posted from http://www.ExcelForum.com Because the spreadhseet is "live". You have to go into edit mode t make any changes to control toolbox items. -- Message posted from http://www.ExcelForum.com I'm not trying to edit my active x forms, The problems is that th standard ctrl+c and ctrl+v copy and paste short cuts wont work unles the active x edit mode is turned on. I don't have to turn on the active x edit mode to use these short cut in other wo...

Find Replace with Macro
Can anyone tell me how to construct a macro that will seacrh the entire contents of column C, find the contacts of cell A1 and replace it with B1, then do the same finding A2 and replacing it with B2 in column C, then A3 with B3 in column C etc etc. I can not get this to work. Sub Test() Dim r1 as Range Dim r2 as Range For Each r1 in Range("A1:A" & Range("A65536").End(xlUp).Row For Each r2 in Range("C1:C" & Range("C65536").End(xlUp).Row If r1.Value = r2.Value Then r2.Value = Range("B" & r1.Row).Value Next Next End Sub -...

Duplicate Emails
Hi all, we have started receiving duplicate emails to out bt/yahoo account. Noone has changed our settings so cannot see why this is happening .... any suggestions on how to resolve please? Thanks in advance. "infinitymum" <infinitymum@discussions.microsoft.com> wrote in message news:5A040556-F362-42F5-8324-43CFA4089908@microsoft.com... > Hi all, we have started receiving duplicate emails to out bt/yahoo > account. > Noone has changed our settings so cannot see why this is happening .... > any > suggestions on how to resolve please? Thanks in adv...

Workflow email via web service
This is what I would like to do: Use workflow to call a web service when an order is created The web service creates an email using SDK Order details are added to the email Is this possible? Has anyone done this before? Thank You Tim workflow calls to webservice, with which the authenticated user loses itself, you must force it in webconfig >-----Original Message----- >This is what I would like to do: > >Use workflow to call a web service when an order is created >The web service creates an email using SDK >Order details are added to the email > >Is this poss...

Email links open to My Documents
When I go to my blue hyperlinks in Outlook 2003, instead of being taken to the website, I am taken to my own My Documents....when I right click, I cannot copy and paste because the copy is grayed out. I really need to repair this ASAP and would appreciate any help. I am using Office 2003 and Windows XP Pro. Thank you! Try rebooting your system >-----Original Message----- >When I go to my blue hyperlinks in Outlook 2003, instead of being taken to >the website, I am taken to my own My Documents....when I right click, I >cannot copy and paste because the copy is grayed out. &...

Can't open html format email in outlook xp
Dear all , I can't open and create html format emails in outlook XP . I think I lost some html and RTF components , I tried to reinstall the outlook xp and selected all the related options , but still can't work. Could anyone help me to solve the problem? Thank in advance Stanley ...