If you are aware of basics of VBA coding, please visit the below site:
http://www.rondebruin.nl/sendmail.htm
Definitely, you will be getting more than what you want... ;)
Maddy...
On Jan 5, 10:13 am, "shay shay" wrote:
> Hello All,
>
> I have an excel sheet and it contains 80
HI Shay,
U hav to add outlook reference to do so.
In your macro screen go to Tools->References
here search for "Microsoft outlook object library " select the
checkbox corresponding to it n the click ok.
Now run the macro this has to work..
REgards
Girish K Rao
On Jan 5, 6:37 pm, "shay shay" w
om
Sent: Monday, January 5, 2009 8:15:35 PM
Subject: Re: $$Excel-Macros$$ Re: Mail merge activity from excel to Outlook!!!
URGENT!
Hi Shay,
Here is the solution. just change the " smtp..com" which is in the
CDO_Mail_Small_Text procedure with the appropriate one.
let me kno
do/configuration/sendusing";) = 2
>> .Item("
>> http://schemas.microsoft.com/cdo/configuration/smtpserver";) = "
>> smtp..com"
>> .Item("
>> http://schemas.microsoft.com/cdo/configuration/smtpserverport";) = 25
>
://schemas.microsoft.com/cdo/configuration/smtpserverport";) = 25
> .Update
> End With
>
> With iMsg
>
>Set .Configuration = iConf
>.To = strTo
> ' .CC = strCC
> ' .BCC = strBCC
> .from = strFrom
>
Along the same lines, I am trying to email from Excel, but I only want
to email only from the current row after I right click on cell 13 in
that particular row. Here is just a snippet of what I found that uses
a For Next loop, but I only want the selected row, not all 8200+ rows.
How can this be c
' .CC = strCC
' .BCC = strBCC
.from = strFrom
.Subject = strSubject
.TextBody = strBody
.Send
End With
End Sub
____
________________
____________
>
>From: shay shay
To: excel-macros@googlegroups.com
Sent: Monday, January 5
Girish,
I am facing an error as User- defined type not defined for all
Dims.
Regards,
Shay
On Mon, Jan 5, 2009 at 5:42 PM, girishkr...@gmail.com wrote:
>
> This module can help u out in sending email by outlook,
> I have considered data is been in "sheet1" and email id in Col"A"
> s
This module can help u out in sending email by outlook,
I have considered data is been in "sheet1" and email id in Col"A"
subject in "col C"
add body of the email as u want in space provided.
This will send all the emails through your current profile itself,
whichever would be activated in your ou
