Hello all, I would like to create a button on an excel spreadsheet that will copy contents of the tab to an email body. This specific tab will be updated as well on a daily basis to make it easier for users to generate daily email with subject lines (including day). Im a newbie to macro and I have no idea how to code
vbaxrmx, welcome to the forum.
Can't do much without an example file.
Explain clearly what you want to be copied to emailbody.
Attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.
Remember to desensitize the data.
Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.
Avoid using Select, Selection and Activate in your code. Use With ... End With instead.
You can show your appreciation for those that have helped you by clicking the * at the bottom left of any of their posts.
I dont really have an example handy. Basically i have an excel spreadsheet with tabs and a table with daily activity reports. I would like to copy the entire content of the daily activity report to an email body that would be sent out to a specific group from my outlook contacts. Example: on my excel speedsheet, I will have:
7- 9 am -- had coffee and started work
9-6 pm -- work on project ABC.
Then when the user clicks on the new button "Email" . An email will be generated with the subject line including the specific day and email body with this specific format:
Good morning, please see below my daily activities:
7- 9 am -- had coffee and started work
9-6 pm -- work on project ABC.
Regards,
Basically i need the entire excel sheet content copied and then passed on to an formatted email body with the subject line including the report day/ date.
I dont really have an example handy. Basically i have an excel spreadsheet with tabs and a table with daily activity reports. I would like to copy the entire content of the daily activity report to an email body that would be sent out to a specific group from my outlook contacts. Example: on my excel speedsheet, I will have:
7- 9 am -- had coffee and started work
9-6 pm -- work on project ABC.
Then when the user clicks on the new button "Email" . An email will be generated with the subject line including the specific day and email body with this specific format:
Good morning, please see below my daily activities:
7- 9 am -- had coffee and started work
9-6 pm -- work on project ABC.
Regards,
Basically i need the entire excel sheet content copied and then passed on to an formatted email body with the subject line including the report day/ date.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks