Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Bypass: A program is trying to send mail using Item.Send prompt | Excel Discussion (Misc queries) | |||
Send an e-mail | Excel Discussion (Misc queries) | |||
Send e-mail | Excel Discussion (Misc queries) | |||
Can I record or write a macro to send a worksheet via Outlook? | Excel Discussion (Misc queries) | |||
Send Mail | Excel Programming |