Thread
:
Using VBA write a mail to some one and Send it
View Single Post
#
1
Posted to microsoft.public.excel.programming
Bero
external usenet poster
Posts: 4
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!
Reply With Quote
Bero
View Public Profile
Find all posts by Bero