#1
|
|||
|
|||
Creating a list using Mail Merge
I use mail merge all the time for labels, emails, certificates, etc. However I've run into an issue that I cannot figure out. I am creating a list of donors in our newsletter. Their names are already in an Excel file (the data source). I would like to just list all of the names with a bullet (or some other character) separating each name. Example:
Mr. John Smith ○ Mr. and Mrs. William Word ○ Mrs. Cindy Sturgeon It keeps putting the new record on a new page, so I am only getting one name on a page. Any help would be greatly appreciated. Thank you. |
#2
|
|||
|
|||
I would just simply copy them from Excel and paste in Word; convert from table to text (or paste as plain text) then select the list and add the bullet or List Paragraph Style. No need to merge over an intact list.
|
#3
|
|||
|
|||
Thank you.
|
#4
|
|||
|
|||
Convent excel from many rows to one row many columns.
Then mail merge with new many columns sheet. https://www.msofficeforums.com/excel...tml#post178321 |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Mail Merge Macro NOT Creating PDF Files | Trang Nguyen | Mail Merge | 6 | 12-16-2019 02:20 PM |
Attempting to mail merge one list into a document containing 3 pages - each page needs the same list | LisaRH | Mail Merge | 3 | 08-09-2018 03:01 PM |
Mail Merge - Creating customer account | Georgina Owen | Mail Merge | 5 | 05-18-2018 03:02 PM |
Creating Hyperlinks after a Mail Merge | jeffreybrown | Mail Merge | 4 | 09-19-2017 06:35 PM |
Creating recipient list for mail-merge | Roger Keeling | Mail Merge | 2 | 05-23-2015 04:34 AM |