ExcelBanter - Using VBA write a mail to some one and Send it

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Using VBA write a mail to some one and Send it (https://www.excelbanter.com/excel-programming/294852-using-vba-write-mail-some-one-send.html)

Bero

Using VBA write a mail to some one and Send it

Hi!

I have:

A1=

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"...

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Juan Pablo González

Using VBA write a mail to some one and Send it

Bero wrote:
Hi!

I have:

A1=

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"...

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Try he

www.rondebruin.nl/sendmail.htm

--
Regards,

Juan Pablo González

All times are GMT +1. The time now is 11:07 PM.