+ Reply to Thread
Results 1 to 6 of 6

Excel Data to Microsoft Outlook Email

  1. #1
    Registered User
    Join Date
    08-05-2017
    Location
    AUSTRALIA
    MS-Off Ver
    Microsoft Excel 2010
    Posts
    23

    Excel Data to Microsoft Outlook Email

    Hi,

    Is it possible for a macro to select and send specific grouped data based off a single cell's value?

    On the attached workbook I want to send data from columns A-Q grouped by the email address in column AA.

    The desired reslut is an email like the attached picture example.

    Thank you in advance!
    Attached Images Attached Images
    Attached Files Attached Files

  2. #2
    Registered User
    Join Date
    05-14-2020
    Location
    Mauritius
    MS-Off Ver
    Office 365
    Posts
    97

    Re: Excel Data to Microsoft Outlook Email

    Hello,

    Questions about this.

    1. The grouping will be done manual?
    2. The inserted table in the email needs to be editable or it could be a picture also?
    Greetings

    Tor


  3. #3
    Forum Expert
    Join Date
    05-29-2020
    Location
    NH USA
    MS-Off Ver
    365
    Posts
    2,102

    Re: Excel Data to Microsoft Outlook Email

    The attached workbook works for one manually selecting the items to send. One will have to enter the email. I haven't been able to get that to work
    Attached Files Attached Files

  4. #4
    Forum Expert
    Join Date
    05-29-2020
    Location
    NH USA
    MS-Off Ver
    365
    Posts
    2,102

    Re: Excel Data to Microsoft Outlook Email

    I have been able to get the file working as per your specs. Note columns from Q to AA are also included in the email report. If you can move the email column over I can update the code. The email vlaue has to be in the selected range for this method to work. Other Notes: This code writes to Range BB and then deletes that data. It also creates new worksheets that are then deleted. I leveraged the page below.

    Please Login or Register  to view this content.
    I used information from two primary sites to make this code work. This code helped with the emailing part https://www.rondebruin.nl/win/s1/outlook/bmail2.htm
    and this helped with the filtering part.
    https://www.listendata.com/2015/04/e...asting-to.html
    Let us know if you have any questions.
    Attached Files Attached Files
    Last edited by maniacb; 06-07-2020 at 06:45 PM.

  5. #5
    Forum Expert
    Join Date
    05-29-2020
    Location
    NH USA
    MS-Off Ver
    365
    Posts
    2,102

    Re: Excel Data to Microsoft Outlook Email

    If the provided solution takes care of your original question, please select*Thread Tools*from the menu link above and mark this thread as SOLVED.

    Also, as a relatively new member of the forum, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped. Thank you in advance.

  6. #6
    Forum Expert
    Join Date
    05-29-2020
    Location
    NH USA
    MS-Off Ver
    365
    Posts
    2,102

    Re: Excel Data to Microsoft Outlook Email

    I resolved the issue of removing the intermediate columns in the attached workbook. Best of luck

+ 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. Attach a Single Sheet to Microsoft Outlook Email with a Macro
    By wherdzik in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-10-2020, 09:56 PM
  2. [SOLVED] Reg: Excel file autosending email using Microsoft Outlook
    By abhimails in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-26-2014, 10:47 AM
  3. [SOLVED] Reg: Excel 2007 file autosending email using Microsoft Outlook 2007
    By abhimails in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-25-2014, 07:34 AM
  4. VBA to Verify an Email Address is Valid in Microsoft Outlook
    By Larry.LeBlanc@O in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 09-16-2014, 10:07 AM
  5. vba pull data from outlook body of email through email or subject of mail into excel
    By breadwinner in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-01-2014, 04:37 AM
  6. How to parse data in Outlook email using HTML version of email back to excel
    By bnasty in forum Excel Programming / VBA / Macros
    Replies: 21
    Last Post: 10-31-2012, 02:54 PM
  7. [SOLVED] Create Microsoft Outlook CalenderEvents from data in Excel Spreads
    By Albert du Toit in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-28-2005, 03:05 PM

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