#1
|
|||
|
|||
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? |
#2
|
||||
|
||||
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) (2002-2019) Visit my web site for more programming tips and ready made processes www.gmayor.com |
#3
|
|||
|
|||
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? |
#4
|
||||
|
||||
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) (2002-2019) Visit my web site for more programming tips and ready made processes www.gmayor.com |
#5
|
|||
|
|||
The data source is sql server 2012 database.
|
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 |