Dear experts
I have set of macro to send mail with mapping of cell range along with attachment.... I have been facing one pop-up i want avoid that!!
that not required by time
"DO YOU WANT TO REPLACE THE CONTENTS OF THE DESTINATION CELLS"?
THIS popup remain coming when ever click the button i dont want this popup ever come up.....I want directly range map to body of email and make attachment from target file...
help on this find the attachment of file
Add the two lines of Code as indicated...
Please Login or Register to view this content.
John
If you have issues with Code I've provided, I appreciate your feedback.
In the event Code provided resolves your issue, please mark your Thread as SOLVED.
If you're satisfied by any members response to your issue please use the star icon at the lower left of their post.
Or removeIts not really needed.Please Login or Register to view this content.
Thanks,
Solus
Please remember the following:
1. Use [code] code tags [/code]. It keeps posts clean, easy-to-read, and maintains VBA formatting.Highlight the code in your post and press the # button in the toolbar.2. Show appreciation to those who have helped you by clickingbelow their posts.
3. If you are happy with a solution to your problem, mark the thread as [SOLVED] using the tools at the top.
"Slow is smooth, smooth is fast."
Thanks alot Jaslake & solus Its works amazing
You're welcome...glad I could help.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks