You must be right. I found the 2nd of the 3 pieces of mail I sent myself
later that evening. Later THIS evening I want to run the macro on a subset of
the REAL list.
What about my question regarding sending the same document to only ONE
address at a time instead of the entire column? Among other things, some
e-mail programs look at mail with multiple "TO" addresses as SPAM but I also
don't want any of the recipients to know how many I'm sending out.
"Ron de Bruin" wrote:
Hi
Each of my three e-mail addresses is a different account with a different
name. Thanks for your help. I'm in New York. It is 5:40 PM. Where are you??
It is working, disable one account and send the mail,you will get one mail.
Enabled the other account and you will see you will receive a mail
I live in the Netherlands in Europe
--
Regards Ron de Bruin
http://www.rondebruin.nl
"MrMan&Fam" wrote in message ...
Each of my three e-mail addresses is a different account with a different
name. Thanks for your help. I'm in New York. It is 5:40 PM. Where are you??
"Ron de Bruin" wrote:
Hi MrMan&Fam
it is only sending e-mail to the 1st address
That's because they all yours and you will receive them.
See this example on my website
http://www.rondebruin.nl/mail/folder2/files.htm
It is bed time for me now ( 23:31) but is if you need help post back and I will help
you tomorrow after work.
--
Regards Ron de Bruin
http://www.rondebruin.nl
"MrMan&Fam" wrote in message ...
I can NOT believe it! Without knowing what the hell I was doing, I followed
your instructions and did (I believe) everything right. As a test, I created
a NEW column "C" with only 3 e-mail addresses (all mine), I edited the
attachment name, the "CC", all went well. I even got a message saying that
"the computer is sending mail. This could be a virus..." BUT, it is only
sending e-mail to the 1st address. It's listing all the other addresses in
the "TO" section but it is not sending to the other addresses. Only the 1st
one. Also, can I have it put only ONE ""TO" address and make a separate
e-mail for each address (not putting them all on the "TO" section). Thanks.
Great job!
"Ron de Bruin" wrote:
Here we Go
Only working if you use Outlook this example
Open a new workbook
InsertModule from the menu bar
Paste the sub in there
Change the path/filename to the word Doc in the code
Alt-Q to go back to Excel
Now in the C column of "Sheet1" fill in your addresses
Save the file
If you do Alt-F8 you get a list of your macro's
Select "Mail_workbook_Outlook" and press Run
You can also use a cell in "Sheet1" with the path/filename to the word Doc
if you want.(post back if you need help with that)
For testing you can change .Send to .display in the code
You can see how it look like and press the Send button manual then
--
Regards Ron de Bruin
http://www.rondebruin.nl
"MrMan&Fam" wrote in message ...
Thanks so much for the prompt response. Your work looks brilliant but it's
wasted on me. I don't know anything about programming or programming in
Excel. I don't even know what to do with your program. However, if this is
what it takes, I guess there's no easy way. Thanks, anyway.
"Ron de Bruin" wrote:
Hi
Try this one with the e-mail addresses in "Sheet1" column C
Visit also my site for more examples
Sub Mail_workbook_Outlook()
Dim OutApp As Object
Dim OutMail As Object
Dim cell As Range
Dim strto As String
For Each cell In ThisWorkbook.Sheets("Sheet1") _
.Columns("C").Cells.SpecialCells(xlCellTypeConstan ts)
If cell.Value Like "*@*" Then
strto = strto & cell.Value & ";"
End If
Next
strto = Left(strto, Len(strto) - 1)
Set OutApp = CreateObject("Outlook.Application")
Set OutMail = OutApp.CreateItem(0)
With OutMail
.To = strto
.CC = ""
.BCC = ""
.Subject = "This is the Subject line"
.Body = "Hi there"
.Attachments.Add ("C:\test.doc")
.Send 'or use .Display
End With
Set OutMail = Nothing
Set OutApp = Nothing
End Sub
--
Regards Ron de Bruin
http://www.rondebruin.nl
"MrMan&Fam" wrote in message
...
Say I have an Excel spreadsheet with one column of e-mail addresses. I want
to send the same piece of e-mail (a WORD file) to each address. Is there an
easy way?