Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Email to a distribution list in Excel - Simple Version Please
I'm trying to do something simple. I want to launch an outlook sendmail form
with the "To" field and "Subject Line" field populated. The list of addresses are in Excel. I don't want to automatically send the email. But the distribution string will be created using VBA. How do I just get the outlook send mail form prepopulated and Ready to send? The email hyperlink does exactly what I want to do with the exception that it only sends to one person. I want to send the email to a verified list. Thanks, |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Email to a distribution list in Excel - Simple Version Please
Hi Brian
See for example http://www.rondebruin.nl/mail/folder3/smallmessage.htm Change Send to Display in the code Then look on the tips page how you can change the To line http://www.rondebruin.nl/mail/tips2.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Brian" wrote in message ... I'm trying to do something simple. I want to launch an outlook sendmail form with the "To" field and "Subject Line" field populated. The list of addresses are in Excel. I don't want to automatically send the email. But the distribution string will be created using VBA. How do I just get the outlook send mail form prepopulated and Ready to send? The email hyperlink does exactly what I want to do with the exception that it only sends to one person. I want to send the email to a verified list. Thanks, |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Email to a distribution list in Excel - Simple Version Please
Ron de Bruin covers almost all situations you could think of he
http://www.rondebruin.nl/sendmail.htm the sample code should require minimal modification to achieve what you want. -- Regards, Tom Ogilvy "Brian" wrote: I'm trying to do something simple. I want to launch an outlook sendmail form with the "To" field and "Subject Line" field populated. The list of addresses are in Excel. I don't want to automatically send the email. But the distribution string will be created using VBA. How do I just get the outlook send mail form prepopulated and Ready to send? The email hyperlink does exactly what I want to do with the exception that it only sends to one person. I want to send the email to a verified list. Thanks, |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Email to a distribution list in Excel - Simple Version Please
Thanks... I found the link just shortly after I posted. I was able to get
the result I wanted based on your sample code. Thanks for the help! "Ron de Bruin" wrote: Hi Brian See for example http://www.rondebruin.nl/mail/folder3/smallmessage.htm Change Send to Display in the code Then look on the tips page how you can change the To line http://www.rondebruin.nl/mail/tips2.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Brian" wrote in message ... I'm trying to do something simple. I want to launch an outlook sendmail form with the "To" field and "Subject Line" field populated. The list of addresses are in Excel. I don't want to automatically send the email. But the distribution string will be created using VBA. How do I just get the outlook send mail form prepopulated and Ready to send? The email hyperlink does exactly what I want to do with the exception that it only sends to one person. I want to send the email to a verified list. Thanks, |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Email to a distribution list in Excel - Simple Version Please
On 8 Jul., 19:18, Brian wrote:
I'm trying to do something simple. *I want to launch an outlook sendmail form with the "To" field and "Subject Line" field *populated. *The list of addresses are in Excel. *I don't want to automatically send the email. *But the distribution string will be created using VBA. How do I just get the outlook send mail form prepopulated and Ready to send? *The email hyperlink does exactly what I want to do with the exception that it only sends to one person. *I want to send the email to a verified list. Thanks, Hi Brian, use the following function to send an Email via Outlook: Dim olApplication As Object Dim objEMail As Object Set olApplication = CreateObject("Outlook.Application") Set objEMail = olApplication.CreateItem(olMailItem) With objEMail .To = recipient If CCrecipient < "" Then .CC = CCrecipient End If .Subject = StrSubject .Body = MailText .display End With Set olApplication = Nothing Set objEMail = Nothing "recipient" is the Email-Address to which you send the email, CCrecipient is the recipient to which you send the mail via CC (carbon copy), StrSubject is the subject of the mail and MailText is the body ("text") of the mail. ".display" means that the mail will be displayed in Outlook before sending and you have to manually press "send mail". If you want to have more than one recipient to your mail simply use a ";" between the different addresses (e.g. ; " in either the "recipient" or "CCrecipient" variable. HTH, Andy |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using VBA to send email to distribution list ... how to CC? | Excel Programming | |||
text box or list box values get sent to email distribution list | Excel Programming | |||
using text box or list boxes info for email distribution list | Excel Programming | |||
How to embed email link in excel document to distribution list | Excel Worksheet Functions | |||
Email distribution list | Excel Programming |