#1
|
|||
|
|||
Mailmerge printing with field names
Brand new to this.
Can successfully mail merge but always get one page with just fieldnames instead of data. How do I turn that off? |
#2
|
||||
|
||||
That suggests there's a dummy record in your data source with just the field names.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#3
|
|||
|
|||
Quote:
My test file has the header record and 1 real record. |
#4
|
||||
|
||||
And are you using the header row field names as the mergefield names, or do they have names like «F1», «F2», etc?
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#5
|
|||
|
|||
Yes they are merge field names, ie. CompName, CompAddr, etc.
|
#6
|
||||
|
||||
Mailmerges don't ordinarily output the headers as separate records. Can you attach the mailmerge main document and Excel worksheet to a post with some representative data (delete anything sensitive)? I only need the document with mergefields and the workbook with a few records. You do this via the paperclip symbol on the 'Go Advanced' tab at the bottom of this screen.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#7
|
|||
|
|||
Quote:
This is its contents: "Company","Physical Address","Physical City State","Owner","SIC Code","Rate Class","Mailing Address","Mailing City State" "BYRD'S BARGAINS & WOODWORK","762 HIGHWAY 15 S","ST. GEORGE, SC","","5999","2","140 WHITE OAK LN","HARLEYVILLE, SC 29448" Could it be you cannot have spaces in the mergefield names? |
#8
|
||||
|
||||
OK, the issue you're having has nothing to do with mailmerge, but with the macro in your mailmerge main document.
The first executable line in your macro is: Dialogs(wdDialogFilePrint).Show Unless you cancel out of that, it prints your mailmerge main document. That explains why you're getting a file with the fieldnames being printed. In any event, you don't need that line, because the rest of the macro sends the actual mailmerge output to the printer. Finally, given that you're using a macro to drive the process, there's no need for your mailmerge main document to be anything other than a normal document (i.e. one that wouldn't give the SQL prompt when you open it).
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#9
|
|||
|
|||
Quote:
The macro that merges just has sendtoprinter and I do not know how to specify their choice. I'm not sure why you think this should be a normal doc. If I don't attach a data file, how will the doc know what the field names are? |
#10
|
||||
|
||||
Try it with the attached. Note that the revised code uses the PrintSetup dialogue, rather than the FilePrint dialogue. You also won't get the SQL prompt, but the mailmerge will work anyway.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Adding names to sheet for printing | WV8VFD | Excel | 4 | 12-01-2013 11:02 PM |
Yes/No field does not work in mailmerge | Abacus1234 | Mail Merge | 10 | 10-14-2013 06:37 AM |
Merge Word documents using a mailmerge field | Concertina | Mail Merge | 3 | 02-18-2013 04:12 AM |
auto insert names from list for printing | andreipopa2k | Word | 1 | 12-09-2011 01:51 PM |
Printing document with style names | Steve_D | Word | 0 | 12-10-2009 09:23 PM |