Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 11-05-2020, 11:57 AM
jmcsa3 jmcsa3 is offline mailmerge not using recipient list Windows 10 mailmerge not using recipient list Office 2019
Novice
mailmerge not using recipient list
 
Join Date: Jan 2019
Location: UK
Posts: 14
jmcsa3 is on a distinguished road
Default mailmerge not using recipient list





i'm a first time user of mailmerge. I'm running ms office 365 on windows 10. I want to email a word document to multiple users. I do not want to use Outlook's group mailing feature. I do not need the merging feature, I just want to send the document without additions. My data source for email addresses is a named range in an Excel sreadsheet. I have successfully created and can edit a recipient list in Word. I have followed all the step by step wizard provided from the ribbon. I have tried it using the appropriate ribbon commands. I've even tried recording a macro. Either way when I get to the last step I get a message box reqesting a recipent and other data. The inputbox in the message window shows the first email of my recipient list and is anyway "greyed out". If i resort to the Finish and Merge ribbon command I get an error msg telling me that an email can't be sent without an addessee.
msgbox.png

error msg.png
Reply With Quote
  #2  
Old 11-05-2020, 07:47 PM
macropod's Avatar
macropod macropod is online now mailmerge not using recipient list Windows 10 mailmerge not using recipient list Office 2010
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

Cross-posted at: ms word mailmerge does not recognise the installed recipient list - Stack Overflow
For cross-posting etiquette, please read: Excelguru Help Site - A message to forum cross posters
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #3  
Old 11-06-2020, 12:04 AM
jmcsa3 jmcsa3 is offline mailmerge not using recipient list Windows 10 mailmerge not using recipient list Office 2019
Novice
mailmerge not using recipient list
 
Join Date: Jan 2019
Location: UK
Posts: 14
jmcsa3 is on a distinguished road
Unhappy Word mailmerge

Sorry to offend. It was not planned. Not entirely sure I understand the url requirement but will not cross post again
Sadly none of this solves my issue.
Reply With Quote
  #4  
Old 11-06-2020, 12:22 AM
macropod's Avatar
macropod macropod is online now mailmerge not using recipient list Windows 10 mailmerge not using recipient list Office 2010
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

The email address for each record must be included in the source data for that record - not in the mailmerge main document. A mailmerge main document cannot be its own data source.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #5  
Old 11-06-2020, 03:12 AM
jmcsa3 jmcsa3 is offline mailmerge not using recipient list Windows 10 mailmerge not using recipient list Office 2019
Novice
mailmerge not using recipient list
 
Join Date: Jan 2019
Location: UK
Posts: 14
jmcsa3 is on a distinguished road
Default word mailmerge

My data source is a spreadsheet named range. i have created a link from my word document using usng Select Recipients\Use an existing list... I have edited the list by removing all addresses except my own (I don't want 120 people getting junk mail until I get this working properly). I've tested this scenario in Outlook to be sure it copes with emailing oneself. Despite that the Finish and Merge command produces the outcome I described in my initial post. The source email is stored as text. I've tried converting the source data to Hyperlik but that does not help.
Reply With Quote
  #6  
Old 11-07-2020, 07:00 AM
jmcsa3 jmcsa3 is offline mailmerge not using recipient list Windows 10 mailmerge not using recipient list Office 2019
Novice
mailmerge not using recipient list
 
Join Date: Jan 2019
Location: UK
Posts: 14
jmcsa3 is on a distinguished road
Default

Problem solved. The Excel range I supplied to Word did not include a header. Apparently if the first value in the range is a valid email address Word Mailmerge gives the msg and subsequent error shown in my original post.
Reply With Quote
Reply

Tags
word maimerge problem

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
mailmerge not using recipient list Edit mailmerge recipient list using a macro hhorber Mail Merge 0 12-17-2019 11:48 AM
mailmerge not using recipient list Creating recipient list for mail-merge Roger Keeling Mail Merge 2 05-23-2015 04:34 AM
mailmerge not using recipient list Sorting numerically in recipient list greengauge Mail Merge 2 05-19-2013 09:58 AM
mailmerge not using recipient list How to edit recipient list rsmedley Mail Merge 1 03-17-2012 01:35 AM
Problem with Edit Recipient List TanMan Word 0 10-05-2011 12:34 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 06:44 AM.


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