Hi Guys
I am writing the following piece of code to send an attachement through email using VBA. It works fine. The only thing is my client wants to view it first before sending.
So the attachement should be in the email and all the recipients name should be in To section of the email outlook window and then the users will press SEND button on email manually to send it.
Can this be done? Can anyone change the code accrodingly.
Thanks
Please Login or Register to view this content.
change send to show
Hope this helps
Sometimes its best to start at the beginning and learn VBA & Excel.
Please dont ask me to do your work for you, I learnt from Reading books, Recording, F1 and Google and like having all of this knowledge in my head for the next time i wish to do it, or wish to tweak it.
Available for remote consultancy work PM me
It's in your code, as a comment
Please Login or Register to view this content.
If you are pleased with a member's answer then use the Star icon to rate it.
@buran.
Thanks .Display worked fine. Now If I want to send the email to around 10 people then where shall I add email addresses of all of them? Thanks again.
Read/learn something aman1234!
If I write .To statement as many times as the email addresses then in the email window only first email address appears.. Any ideas??
Thanks for looking. I resolved it myself using google Nathansav
Feel good?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks