Using VBA write a mail to some one and Send it

  • Thread starter Thread starter Bero
  • Start date Start date
B

Bero

Hi!

I have:

A1= (e-mail address removed)
[email protected]
[email protected]
D1=C:\ExcelQuestionsReply\Peter.doc

How can I from VBA attach the file which the fulladress is located in
D1,
to the following people, Doing something like...:

with ?????? 'I have no Idea
.To = Range("A1").value
.Bcc = Range("B1").value
.CC= Range("C1").value
.Subject = "Automated Mail Response"
.Body = "I am trying to use this as a test E-mail _
using Outlook?? and Excel from code to send and _
add attachments"
.Attachments.Add (Range("D1").value)
End with

How can avoid problems if, I am the only one using Outlook, say you use
Netcaptor?

Any Help??
If Yes then "Please"...
 
Bero said:
Hi!

I have:

A1= (e-mail address removed)
[email protected]
[email protected]
D1=C:\ExcelQuestionsReply\Peter.doc

How can I from VBA attach the file which the fulladress is located in
D1,
to the following people, Doing something like...:

with ?????? 'I have no Idea
.To = Range("A1").value
.Bcc = Range("B1").value
.CC= Range("C1").value
.Subject = "Automated Mail Response"
.Body = "I am trying to use this as a test E-mail _
using Outlook?? and Excel from code to send and _
add attachments"
.Attachments.Add (Range("D1").value)
End with

How can avoid problems if, I am the only one using Outlook, say you
use Netcaptor?

Any Help??
If Yes then "Please"...
Click to expand...

Try here:

www.rondebruin.nl/sendmail.htm
 
Back
Top