+ Reply to Thread
Results 1 to 2 of 2

Mail Merge multiple lines of data in one email

  1. #1
    Registered User
    Join Date
    10-25-2017
    Location
    Chicago, IL
    MS-Off Ver
    2013
    Posts
    15

    Mail Merge multiple lines of data in one email

    Hello - I'm trying to find a way to set up a mail merge for multiple lines of data. I want only ONE email sent out to each recipient but in that email it would list out multiple lines of data. I don't really care how it formats - could be a table, bulleted list, etc. Here is how my excel sheet is set up. My data in excel is set up in column A to list the recipients email and in column B the data I want to send to them in one email. The data sheet will list their email for every policy they own but I want to avoid sending multiple emails (one for each policy) but rather it send ONE email with a list of all the policies they own. Example below.

    Email Policy
    [email protected] Policy A
    [email protected] Policy B
    [email protected] Policy C
    [email protected] Policy D
    [email protected] Policy Z
    [email protected] Policy Y

    I'd like to send an automated email to all recipients using mail merge that would look something like this...

    Hi Laura or [Recipient]

    Below is a list of all of the Policies we have on file that you own. Please verify.

    Policy A
    Policy B
    Policy C
    Policy D

    Thank you,

    Bob

  2. #2
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    17,535

    Re: Mail Merge multiple lines of data in one email

    Perhaps this will help in formatting the data in preparation to be mail merged.
    1. Populate column C using: =IF(A2<>A3,LEFT(A2,SEARCH("@",A2)-1),"")
    2. Populate column D using: =IF(OR(ROW()=2,C1<>""),B2,D1&CHAR(10)&B2)
    3. Populate the output name column (F) using: =IFERROR(INDEX(C$2:C$7,AGGREGATE(15,6,(ROW(C$2:C$7)-ROW(C$1))/($C$2:$C$7<>""),ROWS(F$2:F2))),"")
    4. Populate the output policy column (G) using: =IFERROR(INDEX(D$2:D$7,AGGREGATE(15,6,(ROW(D$2:D$7)-ROW(D$1))/($C$2:$C$7<>""),ROWS(G$2:G2))),"")
    Let us know if you have any questions.
    Attached Files Attached Files
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

+ 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. Replies: 0
    Last Post: 10-10-2022, 05:40 PM
  2. Mail Merge Auto Email VBA - Multiple CCs.
    By Rilly in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-06-2020, 05:16 PM
  3. Mail Merge Directory - Creating merge with multiple lines
    By tiggynook in forum Excel General
    Replies: 3
    Last Post: 05-03-2017, 03:00 PM
  4. Replies: 1
    Last Post: 12-02-2014, 06:13 AM
  5. Replies: 3
    Last Post: 10-14-2014, 11:33 AM
  6. Mail merge with multiple lines of data in excel to feed one Word doc
    By gaucher2013 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 12-12-2012, 02:57 PM
  7. mail merge to email
    By newangel90 in forum Word Formatting & General
    Replies: 1
    Last Post: 12-10-2010, 12:53 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