Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 11-29-2023, 07:22 AM
PghPens508 PghPens508 is offline Creating a list using Mail Merge Windows 10 Creating a list using Mail Merge Office 2021
Novice
Creating a list using Mail Merge
 
Join Date: Nov 2023
Posts: 2
PghPens508 is on a distinguished road
Default 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.
Reply With Quote
  #2  
Old 11-29-2023, 09:19 AM
kilroyscarnival kilroyscarnival is offline Creating a list using Mail Merge Windows 10 Creating a list using Mail Merge Office 2021
Expert
 
Join Date: May 2019
Posts: 344
kilroyscarnival is just really nicekilroyscarnival is just really nicekilroyscarnival is just really nicekilroyscarnival is just really nice
Default

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.
Reply With Quote
  #3  
Old 11-29-2023, 09:36 AM
PghPens508 PghPens508 is offline Creating a list using Mail Merge Windows 10 Creating a list using Mail Merge Office 2021
Novice
Creating a list using Mail Merge
 
Join Date: Nov 2023
Posts: 2
PghPens508 is on a distinguished road
Default

Thank you.
Reply With Quote
  #4  
Old 11-29-2023, 05:32 PM
zpy2 zpy2 is offline Creating a list using Mail Merge Windows 10 Creating a list using Mail Merge Office 2013
Novice
 
Join Date: Sep 2023
Location: China
Posts: 28
zpy2 is on a distinguished road
Default

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
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Creating a list using Mail Merge 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
Creating a list using Mail Merge Mail Merge - Creating customer account Georgina Owen Mail Merge 5 05-18-2018 03:02 PM
Creating a list using Mail Merge Creating Hyperlinks after a Mail Merge jeffreybrown Mail Merge 4 09-19-2017 06:35 PM
Creating a list using Mail Merge Creating recipient list for mail-merge Roger Keeling Mail Merge 2 05-23-2015 04:34 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 10:19 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft