+ Reply to Thread
Results 1 to 7 of 7

combining and splitting data and sending to emails in a column

  1. #1
    Registered User
    Join Date
    10-01-2021
    Location
    droitwich
    MS-Off Ver
    office 365
    Posts
    8

    combining and splitting data and sending to emails in a column

    Hi

    I Have a list of data in columns with the email address i wish to send the data to in the final column.

    The problem is the email addresses repeat and I wish to send all the data for a relevant email address in one email. (the file attached should make this clearer)

    any help or possible solutions appreciated.
    Attached Files Attached Files

  2. #2
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... based in Ireland... but I could be anywhere in the world
    MS-Off Ver
    Office 365 for PC.
    Posts
    34,926

    Re: combining and splitting data and sending to emails in a column

    I'm not entirely clear about what you expect to see... maybe:

    =UNIQUE(E2:E30)
    Glenn



  3. #3
    Registered User
    Join Date
    10-01-2021
    Location
    droitwich
    MS-Off Ver
    office 365
    Posts
    8

    Re: combining and splitting data and sending to emails in a column

    Hi

    I'm trying to email the data in columns A:D to the email address in E

    so there are multiple rows that need to be sent in one email.

    Thanks
    James

  4. #4
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel (Windows 11 64-bit)
    Posts
    62,150

    Re: combining and splitting data and sending to emails in a column

    Give us an example of the expected output.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" to anyone who has offered you help in your thread. You can reward them by clicking on * Add Reputation below theur user name on the left, if you wish.


    Forum Rules (updated September 2018): please read them here.
    How to use the Power Query code you've been given: help here. More about the Power suite here.

  5. #5
    Registered User
    Join Date
    10-01-2021
    Location
    droitwich
    MS-Off Ver
    office 365
    Posts
    8

    Re: combining and splitting data and sending to emails in a column

    Hi So the below would be sent in an email to sales at hireandbuy


    Item No. Description
    JS1543HM S1543HM BOSCH SABRE BLADE
    PICA524-44 Pica Paint Marker Round Tip 2-4mm Yellow
    PICA524-52 Pica Paint Marker Round Tip 2-4mm White
    PTI0228 PTI 34MM PRECISION PLUNGE BLADE 3PC SET
    PTI0229 PTI 68MM PRECISION PLUNGE BLADE 3PC SET
    PTI0230 PTI 34MM BI-METAL PLUNGE BLADE 3PC SET
    PTI0232 PTI 88MM BI-METAL SEGMENT SAW BLADE

    Thanks
    James

  6. #6
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel (Windows 11 64-bit)
    Posts
    62,150

    Re: combining and splitting data and sending to emails in a column

    OK, but how do you want it to be presented? Multiple rows? In one cell?

    Do you want the putput for one company or for all?

    Provide a sample workbook showing us what we are aiming for. I'm not able to visualise what that is.

  7. #7
    Registered User
    Join Date
    10-01-2021
    Location
    droitwich
    MS-Off Ver
    office 365
    Posts
    8

    Re: combining and splitting data and sending to emails in a column

    Hi sorry, I'll try to explain it in full.

    We have a spreadsheet with all of the dropped of sales from our customers (as per attached to opening post). I want to be able to send out a batch of emails (1 to each customer)
    with a list of the dropped off sales for that customer. Preferably as a small table (which would just show the item number and description)

    From my understanding I can use a mail merge to send out each line to the email address in column e but i want to send all the lines relevant to that customer in one email

    so from the original attachment "hire and buy" would receive rows 2 to 8, columns C and D in table form with some additional generic text in the email.

    Thanks
    James

+ 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. Please delete
    By Svenski79 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-02-2018, 02:51 PM
  2. [SOLVED] Sending Outlook emails from Excel; Limits to three emails only?
    By BPSJACK in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-29-2013, 06:53 AM
  3. Sending automatic emails dependant on date in a certain column
    By DannyJ in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-08-2012, 08:51 AM
  4. sending emails using macro button from excel, with variable data
    By GShep in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-27-2012, 06:15 AM
  5. Sending Multiple Emails from Excel data through MS. Out Look
    By mitta23p in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 05-11-2011, 09:31 AM
  6. Sending Outlook emails containing Excel data
    By Richard Buttrey in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-05-2009, 10:24 AM
  7. Sending macro emails using excel: Send emails with their passwords.
    By loveisblind in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-12-2009, 03:16 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