Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 01-24-2014, 12:40 AM
dazwm dazwm is offline Help Sending Mail Merge Document Windows XP Help Sending Mail Merge Document Office 2007
Advanced Beginner
Help Sending Mail Merge Document
 
Join Date: May 2012
Posts: 59
dazwm is on a distinguished road
Default Help Sending Mail Merge Document

I want to send a list of labels via email to a colleague to print. How do I? I will create the file and get the info from an excel document. If I was to print the labels, it looks at the excel file and prints fine. But how do I save it and send it if the recipient does not have the excel document. I have tried before and it only prints the first page when there could be 50!? Thanks.

Last edited by dazwm; 01-24-2014 at 02:28 AM.
Reply With Quote
  #2  
Old 01-24-2014, 09:18 PM
macropod's Avatar
macropod macropod is offline Help Sending Mail Merge Document Windows 7 32bit Help Sending Mail Merge Document Office 2010 32bit
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

If you 'Finish' the merge, sending the output to a new document, you can then save & attach that document to an email.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #3  
Old 01-24-2014, 11:31 PM
dazwm dazwm is offline Help Sending Mail Merge Document Windows XP Help Sending Mail Merge Document Office 2007
Advanced Beginner
Help Sending Mail Merge Document
 
Join Date: May 2012
Posts: 59
dazwm is on a distinguished road
Default

Sorry I don't understand 'sending the output to a new document ' and what about the excel file it has got all the info from?
Reply With Quote
  #4  
Old 01-24-2014, 11:34 PM
macropod's Avatar
macropod macropod is offline Help Sending Mail Merge Document Windows 7 32bit Help Sending Mail Merge Document Office 2010 32bit
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

Did you try it? If you complete the merge as described, Word produces a document with all the labels in-situ. That document has no further need of the data source.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #5  
Old 01-24-2014, 11:44 PM
dazwm dazwm is offline Help Sending Mail Merge Document Windows XP Help Sending Mail Merge Document Office 2007
Advanced Beginner
Help Sending Mail Merge Document
 
Join Date: May 2012
Posts: 59
dazwm is on a distinguished road
Default

I have tried but the recipient can only print the first page.
Reply With Quote
  #6  
Old 01-25-2014, 12:40 AM
macropod's Avatar
macropod macropod is offline Help Sending Mail Merge Document Windows 7 32bit Help Sending Mail Merge Document Office 2010 32bit
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

That suggests you didn't Finish the merge, but only sent a Preview. These are entirely different things... If you Finish the merge, you will see a new document containing all the records.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #7  
Old 01-27-2014, 02:43 AM
dazwm dazwm is offline Help Sending Mail Merge Document Windows XP Help Sending Mail Merge Document Office 2007
Advanced Beginner
Help Sending Mail Merge Document
 
Join Date: May 2012
Posts: 59
dazwm is on a distinguished road
Default

I am using 2007 and there is an option for finish and merge. But in the drop down list there are only choices of edit individual documants, print documents or send email messages. Which one do I select to get the 'new document containing all the records'? Thanks.
Reply With Quote
  #8  
Old 01-27-2014, 03:14 AM
macropod's Avatar
macropod macropod is offline Help Sending Mail Merge Document Windows 7 32bit Help Sending Mail Merge Document Office 2010 32bit
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

Since you don't want to print the output you'd use 'edit individual documents' - for all records.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #9  
Old 01-28-2014, 01:00 PM
dazwm dazwm is offline Help Sending Mail Merge Document Windows XP Help Sending Mail Merge Document Office 2007
Advanced Beginner
Help Sending Mail Merge Document
 
Join Date: May 2012
Posts: 59
dazwm is on a distinguished road
Default

Thanks for your help macropod. I did edit documents then done 'save as' and it seemed to work.
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Help Sending Mail Merge Document Formatting in mail merge document OnTheCouch Mail Merge 1 09-29-2013 07:05 PM
Help Sending Mail Merge Document Mail Merge Doubles My Document ExecAssist Mail Merge 1 02-27-2012 04:06 PM
Help Sending Mail Merge Document Need some help with building a mail merge document. DaveBF Mail Merge 1 09-22-2011 06:53 AM
delete blank pages from mail merge document blusea Word 0 12-17-2010 06:10 PM
sending Emails With Mail-Merge As HTML Problem - Nothing Happen majid000 Mail Merge 0 12-10-2010 07:51 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 05:17 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