View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Juan Pablo González Juan Pablo González is offline
external usenet poster
 
Posts: 226
Default 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