Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How Can I send customized email content by Excel VBA
I have tailor made the email content and wanna send it out to each
individual by use Excel VBA, how can I do? I read a some articles show how to send by using MS-Outlook, but my email application is not Outlook, it is Novell Groupwise, how can I do that? Thank you very much |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How Can I send customized email content by Excel VBA
New;
Take a look at this .. http://www.j-walk.com/ss/excel/tips/tip86.htm Mark. -- Rosenkrantz Spreadsheet Solutions Witkopeend 24 1423 SN Netherlands ------------------------ E: W: www.rosenkrantz.nl ------------------------ "new.microsoft.com" wrote in message ... I have tailor made the email content and wanna send it out to each individual by use Excel VBA, how can I do? I read a some articles show how to send by using MS-Outlook, but my email application is not Outlook, it is Novell Groupwise, how can I do that? Thank you very much |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
How Can I send customized email content by Excel VBA
try using CDO
here's a snippet to get you going Private Sub SendMailCDOCacheConf(aTo, Subject, TextBody, aFrom) Const cdoSendUsingPort = 2 Dim Conf Set Conf = CreateObject("CDO.Configuration") With Conf.Fields .item("http://schemas.microsoft.com/cdo/configuration/sendusing") = _ cdoSendUsingPort .item("http://schemas.microsoft.com/cdo/configuration/smtpserver") _ = "mymailserver.com" .Update End With Dim Message 'As New CDO.Message 'Create CDO message object Set Message = CreateObject("CDO.Message") With Message 'Set cached configuration Set .Configuration = Conf 'Set email adress, subject And body .To = aTo .Subject = Subject .TextBody = TextBody 'Set sender address If specified. If Len(aFrom) 0 Then .From = aFrom 'Send the message .send End With End Sub loads of info on Google for this "new.microsoft.com" wrote: I have tailor made the email content and wanna send it out to each individual by use Excel VBA, how can I do? I read a some articles show how to send by using MS-Outlook, but my email application is not Outlook, it is Novell Groupwise, how can I do that? Thank you very much |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
How Can I send customized email content by Excel VBA
I have take a look of the link, and copied the code, it doesn't work and
show that "ShellExecute" doesn't defined. Moreover I am not using Outlook but using Novell Groupwise 6.0 "Spreadsheet Solutions" wrote in message ... New; Take a look at this .. http://www.j-walk.com/ss/excel/tips/tip86.htm Mark. -- Rosenkrantz Spreadsheet Solutions Witkopeend 24 1423 SN Netherlands ------------------------ E: W: www.rosenkrantz.nl ------------------------ "new.microsoft.com" wrote in message ... I have tailor made the email content and wanna send it out to each individual by use Excel VBA, how can I do? I read a some articles show how to send by using MS-Outlook, but my email application is not Outlook, it is Novell Groupwise, how can I do that? Thank you very much |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
can excel send email? | Excel Discussion (Misc queries) | |||
send email to each customer email in excel sheet. | Excel Discussion (Misc queries) | |||
About using CDO to send email within Excel | Excel Discussion (Misc queries) | |||
send wkbk as an email attachment with an email address copied from | Excel Discussion (Misc queries) | |||
body of email disappears when I send an email from Excel | Excel Discussion (Misc queries) |