+ Reply to Thread
Results 1 to 3 of 3

split/separate rows based on criteria and send those rows by mail

  1. #1
    Registered User
    Join Date
    10-09-2014
    Location
    switzerland
    MS-Off Ver
    2010
    Posts
    15

    split/separate rows based on criteria and send those rows by mail

    Hi everyone - my first thread in here and i hope i got some interesting answers and views

    I created a final database spreadsheet (merged from several sheets together) and now i should do the following:

    - split rows by criteria/"filter" - a.E. on my sheet "column G" where its sorted A-Z (attached picture)
    - Add contact in merged cell (column O) for every bulk of datarange (a.E on picture highlighted in RED)
    - send all those information's to the added mail-contact in column O

    If its possible, as its linked to MO Outlook, to send not only the information's from XLS as i would have to add a TEXT into the mail as well. It would be also like a mass-mail from MO WORD

    There are always about thousands of lines - and honestly i need a automation to do this as i would die by clicking through each line...

    Hope its clear enough and that someone could help me out with this

    I've added a picture so you can see a small bulk of informations how it would look like

    Many Thanks!!
    XLS_example.png

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2403 Win 11 Home 64 Bit
    Posts
    23,811

    Re: split/separate rows based on criteria and send those rows by mail

    Hi and welcome to the forum

    Pictures are of little value. Honestly, no one wants to re-type your data to try and solve your issue. Additionally, we would only be guessing at how your data was structured, ie. formulas, formatting, etc.

    Please attach a sample file that represents what you have. The structure of your attachment should be the same structure as your actual data. Any proprietary information should be changed.

    Include in the attachment any code you're currently using (whether it works or not) and an "After" of what you wish the output to be.

    To attach a file to your post,
    click advanced (next to quick post),
    scroll down until you see "manage file",
    click that and select "add files" (top right corner).
    click "select files" find your file, click "open" click "upload" click 'done" bottom right. click "submit reply"

    Once the upload is completed the file name will appear below the input boxes in this window.
    You can then close the window to return to the new post screen.
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

  3. #3
    Registered User
    Join Date
    10-09-2014
    Location
    switzerland
    MS-Off Ver
    2010
    Posts
    15

    Re: split/separate rows based on criteria and send those rows by mail

    Hi alansidman

    i see! Here you go:

    Datas are copied values - no formulas behind... those are in a separate spready and they where mostly vlookup and probaly some .if formulas.

    and thanks for that quick respond!XLS_example.xlsx

+ 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. Split and send Mail
    By [email protected] in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-23-2013, 12:29 PM
  2. [SOLVED] Splitting mullti-line cells into separate rows and repeat values in columnA after split
    By gracek in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 07-30-2012, 12:21 PM
  3. [SOLVED] Split table, based on two criteria, into separate workbooks
    By gingert88 in forum Excel General
    Replies: 6
    Last Post: 07-10-2012, 06:08 PM
  4. Replies: 1
    Last Post: 05-10-2012, 11:33 AM
  5. Replies: 2
    Last Post: 09-24-2006, 08:33 AM

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