Microsoft Office Forums

Go Back   Microsoft Office Forums > Microsoft Word > Mail Merge

Reply
 
LinkBack Thread Tools Display Modes
  #1  
Old 03-03-2017, 08:08 PM
jassie jassie is offline Windows 7 64bit Office 2007
Novice
 
Join Date: Feb 2012
Posts: 18
jassie is on a distinguished road
Default word 2013 mail merge newbie

I have a few questions to about using the mail merge*feature in word 2013 since this is the first time I have worked with this feature. I am asking this question since I need to modify an existing an existing word 2013 document that uses the mail merge feature:
1. In the document, a pop up window*shows basically that displays select * from view_bne. I then need to hit an ok button for the data to be displayed on each page for each letter. Can you tell me how to change what is displayed* in* the select * from view_bne statement? Is there a way for this select statement not to display every time the word 2013 document is opened and if so how would I change this?
2. There is a window that shows up if I want to change the data source? Thus can you tell me how to change the data source for the word document? Is there a way that can be setup so the popup window does not show up all the time? Basically is there a way for the word document to 'remember' what the connection is?
3. When running the mail merge is there a way that all word document letters can be saved electronically? Basically I may not want to print all the letters right away. I will want to print the letters at a later time?
4. When printing a regular word document you can print specific pages. Basically you can print page 2of 5. Can you tell me how to do that for a file that will have 20,000 letters to print at once?


5. If the mail merge of a word document is executed on one computer and the 20,000 letters are to print on another printer on that is setup on my company's network, how would I set that up?
Reply With Quote
  #2  
Old 03-03-2017, 10:17 PM
gmayor's Avatar
gmayor gmayor is offline Windows 10 Office 2016
Expert
 
Join Date: Aug 2014
Posts: 2,755
gmayor is just really nicegmayor is just really nicegmayor is just really nicegmayor is just really nice
Default

See MailMerge with Word which covers the basics.

To change the data source. Set the document type to normal Word document from the mailings tab 'Start Mail Merge' dropdown. Then Select Recipients.

Save the document to retain the datasource with the document.

Each page of a merge document is a separate section - to print one letter you need to indicate the section to print in the pages dialog e.g. s2

http://www.gmayor.com/individual_merge_letters.htm. will split the merge to separate files for each record, named from the data.


You can print on any printer that the PC can access by selecting that printer as the active printer.


Practice with a much smaller dataset.
__________________
Graham Mayor - MS MVP (Word)
Visit my web site for more programming tips and ready made processes www.gmayor.com
Reply With Quote
  #3  
Old 03-04-2017, 05:13 PM
jassie jassie is offline Windows 7 64bit Office 2007
Novice
 
Join Date: Feb 2012
Posts: 18
jassie is on a distinguished road
Default word 2013 mail merge

Can you give me more directions on how to change;
1. the select statement? and
2. how to print the letter in separate groups?
Reply With Quote
  #4  
Old 03-04-2017, 09:36 PM
gmayor's Avatar
gmayor gmayor is offline Windows 10 Office 2016
Expert
 
Join Date: Aug 2014
Posts: 2,755
gmayor is just really nicegmayor is just really nicegmayor is just really nicegmayor is just really nice
Default

1. What is the data source?

2. Each 'letter' in the merged document is a separate section. In the dialog below:

Type the page numbers with commas between them. Type the range of pages with a hyphen between the starting and ending numbers in the range.
For example, to print pages 2, 4, 5, 6, and 8, type 2,4-6,8

A range of pages within a section

Type p page number s section number.
For example, to print pages 5 through 7 in section 3, type p5s3-p7s3

An entire section

Type s section number.
For example, type s3

Noncontiguous sections

Type the section numbers with commas between them.
For example, type s3,s5

A range of pages across sections

Type a range of page numbers and the sections that contain them with a hyphen between the starting and ending numbers in the range.
For example, type p2s2-p3s5

__________________
Graham Mayor - MS MVP (Word)
Visit my web site for more programming tips and ready made processes www.gmayor.com
Reply With Quote
  #5  
Old 03-06-2017, 08:53 AM
jassie jassie is offline Windows 7 64bit Office 2007
Novice
 
Join Date: Feb 2012
Posts: 18
jassie is on a distinguished road
Default

The data source is sql server 2012 database.
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Mail Merge with variable table length MS Word 2013 rbr Mail Merge 6 11-18-2016 07:05 AM
Creating Barcode Badges using Microsoft Word Mail Merge 2013 Sarah15 Mail Merge 4 04-16-2015 06:03 AM
Labels are not printed the way they are shown on the screen! (Word 2013 via Mail Merge) malinneedshelp Mail Merge 2 12-09-2014 03:08 AM
mail merge with attachment -- office 2013 shmu Mail Merge 5 11-20-2014 04:56 AM
Any Solutions for Word 2013 DBase Mail merge. pld32 Mail Merge 1 01-08-2014 02:49 PM


All times are GMT -7. The time now is 01:51 AM.


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