Recent content by JudyL

My paper trays are set in Page Setup. I am not sure what you mean by "How are you trying to print". The merge results in a merged document and then I send it to the printer. As you know, when you do a mailmere, each time you merge to a new record, a section break is inserted. That seems to be...

I am working on a project for a client who uses Word 2003. they are merging a mailmerge main document with an Excel 2003 file. Each data file record has a field in it specifying the path and another specifying the document and the rest of the record providing data to merge to the document...

Thanks for the reply. I will try your suggestions.

To answer your comments: Quote: When the mailmerge is done, it runs a MailmergeAfterMerge event that unlinks the fields in the resulting document. There should be no need to do this. All mergefields are unlinked during the merge. The only fields that might not be are those containing other types...

I have a macro that changes the active printer and then runs a mailmerge. When the mailmerge is done, it runs a MailmergeAfterMerge event that unlinks the fields in the resulting document. I also want the event code to change the default tray for the printer. When I run the merge, it crashes...

if you want to change the wording in the resulting document based on what is in the Excel data file (that is the data in the merge fields), why don't you use the "If" merge statement to check the value of a field to determine what wording should be in the final document?

My guess is that the macro language would need updating for Excel 2007. The later versions of Crystal don't use the add-in anymore. You can just create a file based on an Excel file. Start your report from Crystal instead of Excel.

Thanks for your reply. I am using the INCLUDEPICTURE field because the picture file to be include varies depending on the value of a field. Because of that the first method won't work. I tried putting the code in a text box but it only sizes the text box. The picture gets cropped. It looks like...

In Word 2003, during a mailmerge, I want to use the mailmerge If statement to include specific pictures depending on the value in the field. I have gotten that part to work. My problem is how to size the graphic. I can position it by using Advance codes just before the If statement. I just need...

I know it can but I have to think of the abilities of the client for whom I am doing this. They can handle modifications to the merge language but vba is beyond them. Though I love to get the work, I do need to keep their budget in mind. It's all about ease of maintenance.

Thanks but I think the assembly of the 130 various file combinations that can be brought in based on field values is too complex to have the whole merge process handled completely by macros. I am also familiar with vba but had not used the Mailmerge events before. I think I will use a...

Thanks.I am familiar with the merge language and have used it quite a bit. This is not a directory or catalog merge. It is a letter of confirmation that has optional text depending on the values in the fields. Your suggestion of having the whole table come in with two versions of it might work...

Thanks for the quick response. To give you an example, depending on the value of a field, we want to include a file. The file contains a couple of rows of a table that will be placed directly beneath an existing table. The macro would combine the two tables. I know I can use the merge coding to...

I am converting some old (very old) WordPerfect Mail Merge main documents to Word 2003. In the old WordPerfect files there was a mail merge statement that allowed you to nest forms and nest macros. The nesting was triggered by If or Select Case mail merge code so that different files or macros...

Thanks. Good to know