+ Reply to Thread
Results 1 to 4 of 4

VBA Macro help copying and emailing excel content

  1. #1
    Registered User
    Join Date
    02-24-2019
    Location
    Houston, USA
    MS-Off Ver
    MAC OS, Windows
    Posts
    3

    VBA Macro help copying and emailing excel content

    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

  2. #2
    Forum Guru bakerman2's Avatar
    Join Date
    10-03-2012
    Location
    Antwerp, Belgium
    MS-Off Ver
    MO Prof Plus 2016
    Posts
    6,901

    Re: VBA Macro help copying and emailing excel content

    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.

  3. #3
    Registered User
    Join Date
    02-24-2019
    Location
    Houston, USA
    MS-Off Ver
    MAC OS, Windows
    Posts
    3

    Re: VBA Macro help copying and emailing excel content

    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.

  4. #4
    Registered User
    Join Date
    02-24-2019
    Location
    Houston, USA
    MS-Off Ver
    MAC OS, Windows
    Posts
    3

    Re: VBA Macro help copying and emailing excel content

    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.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Copying Excel content to Word using drop-down list
    By Kybynn in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 12-18-2017, 05:15 AM
  2. [SOLVED] Code for turning sheet3 content into a pdf and emailing it with cell info all from sheet1
    By Miasage in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-07-2013, 09:56 AM
  3. Copying content of one excel to another excel and sending email with excel data
    By archies.gall in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-26-2012, 02:22 PM
  4. Replies: 0
    Last Post: 02-02-2011, 06:42 PM
  5. emailing content of a worksheet row
    By Healthwatch in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-08-2009, 07:15 PM
  6. Copying Cell Content Across Sheets in Excel 2007
    By ExcelTip in forum Tips and Tutorials
    Replies: 0
    Last Post: 10-31-2007, 04:28 AM
  7. stopping copying and emailing of an Excel file
    By Josh C in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-24-2007, 01:05 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1