Want to change attached file name & subject line in the coding : Email Range

Dear All,

I have put a module in excel vba and assign this macro to a Send Mail button for a range of data in excel sheet. when i click on the sendmail button it automatically compose a msg from outlook and attach that range of data in a excel sheet with a file name "Selection of example.xlsx Date & Time.xlsx" and a subject line "This is a subject line".

Now i want to change the

Name of Attachement to : Order No + "data in C3 cell"
Subject Line to : Order No + "data in C3 cell"

Please find below coading:

Please Login or Register  to view this content.

Please find example.xlsx file for your refrence...

Thanks

Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution. Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.
To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

Kapil,

with your first post in this forum, you managed to ignore three of our forum rules

- code tags around code
- meaningful thread titles
- supply links to crossposts

I strongly suggest you read our forum rules before you participate any more in this forum.

Kapil, after you've read and understood the forum rules, start another thread that complies with our forum rules.

thanks.

thread closed.