Microsoft Office Forums

Go Back   Microsoft Office Forums > Microsoft Word > Mail Merge

Reply
 
LinkBack Thread Tools Display Modes
  #1  
Old 04-06-2012, 03:20 AM
Baldeagle Baldeagle is offline Windows XP Office 2007
Advanced Beginner
 
Join Date: Apr 2012
Posts: 59
Baldeagle is on a distinguished road
Default Email from MailMerge


I have created a Word document that I want to email to a group of people whose details (including email address) are in my Access database. I can do the mailmerge successfully and everything seems fine but when I try to send the emails there are 2 problems -
1. It wants me to confirm that I am happy to send each email! My default programme is Outlook Express but I do have MS Outlook installed. Can I get round this problem?
2. It would appear that although the email addresses are in the linked Access query it won't send the email to anyone whose details are not in my Address Book. Am I misunderstanding something here or do I have to put all the email addresses into the Address Book as well as having them in the Access Table?
Any help would be appreciated.
Reply With Quote
  #2  
Old 04-06-2012, 04:16 AM
macropod's Avatar
macropod macropod is offline Windows 7 64bit Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 16,666
macropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to behold
Default

For the first problem, see: http://www.contextmagic.com/express-clickyes/
For the second problem, AFAIK the addresses don't have to be in your address book. It may be that you configured your mailmerge to use the address book instead of the data source (ie the existing list option) for the addresses to send to.
__________________
Cheers,
Paul Edstein
[MS MVP - Word]
Reply With Quote
  #3  
Old 04-06-2012, 04:31 AM
Baldeagle Baldeagle is offline Windows XP Office 2007
Advanced Beginner
 
Join Date: Apr 2012
Posts: 59
Baldeagle is on a distinguished road
Default

My second problem seems to have been resolved - it is now picking up email addresses that are not in my Address Book.
But the second problem is a message from Outlook Express and not from Outlook. The link you suggested says this fix doesn't operate in Outlook Express. But I have gone into Tools, Options, Security in Outlook Express and have unticked the 'Warn me when other applications try to send mail as me' box but I'm still getting the boxes asking for confirmation that I want to send each email. Is there anything else I need to do?
Reply With Quote
  #4  
Old 04-06-2012, 05:36 AM
macropod's Avatar
macropod macropod is offline Windows 7 64bit Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 16,666
macropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to behold
Default

You may need to close & re-start Outlook Express for the settings to take effect.
__________________
Cheers,
Paul Edstein
[MS MVP - Word]
Reply With Quote
  #5  
Old 04-06-2012, 05:46 AM
Baldeagle Baldeagle is offline Windows XP Office 2007
Advanced Beginner
 
Join Date: Apr 2012
Posts: 59
Baldeagle is on a distinguished road
Smile

Brilliant!! That has solved things. I appreciate your help.
Reply With Quote
Reply

Tags
email, mailmerge

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Mailmerge dkub Mail Merge 35 12-07-2011 11:35 PM
How do you add text to email mailmerge? DerekScambler Mail Merge 10 04-19-2011 05:30 AM
Help with mailmerge??? foxtrot1981 Mail Merge 0 12-03-2010 08:21 AM
MailMerge fax not e-mail? JDCarb Mail Merge 3 04-02-2010 04:10 PM
Mailmerge Formula mridley Mail Merge 0 07-27-2006 03:16 AM


All times are GMT -7. The time now is 08:24 PM.


Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.
MSOfficeForums.com is not affiliated with Microsoft