View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Bero Bero is offline
external usenet poster
 
Posts: 4
Default 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!