Search results for query: *

Thanks, Fox. Your answer was the one I was looking for 6 months ago. I managed to hack this problem away another way, but your post will certainly help me (and others) in the future. Better late than never! Thanks again.

Hmmm, I tried it again and it worked fine. Maybe there was some other issue going on, because I was having other issues with saving the query criteria for the merge. Skip, thanks a bunch for your solution and your time. You get a star! Sean

Skip, I tried (at least I think I did what you mentioned) your approach, and it did not work. I sorted my Excel spreadsheet in least significant order (by last name). I then sorted the data in my mail merge document by Company first, then by State, then by Line 1 address. The merged document...

Then why isn't it Office 2002??? Thanks for the naming tip, jfhewitt...I just assumed that Office XP contained Word XP... I think that the link you posted does apply to my problem, but the kicker is that this document is actually for my wife at her office, so it would be hard to convince them...

The reason for sorting on address is for the cases where a company has multiple locations in one state. The employees must be listed under the company's location where they work. The final report should look something like this: Campbell Soup Company 8367 East Renada Scottsdale, AZ 85255...

I thought of that, but I wasn't sure if that would be enough to guarantee that everything would be sorted properly everytime. It's very important that the sort be correct, as the results will be sent to a printer to be made into directories for a large meeting.

Skip, I'm not quite sure that I understand your answer. I know how to sort my data, but I need four criteria, and Word only allows three. Assume that I have no control over the data source; it's a comma-delimited file that is generated by another application, so I can't reorder the fields. I...

Is it possible to have more than three sorting criteria in a mail merge document in Word XP? I'm creating a company listing that needs to be sorted by company. Under the company the people who work for that company will be listed in alphabetical order by their last name. The thing is that...

Thanks GeekGirlau, that worked. It shouldn't be that difficult, but it worked. A little history, if you care: I created this mail merge in Word 2000. The blank address lines were being suppressed properly. When I opened the document in Word XP, the blank lines were not being surpressed at...

Did you ever find a solution to this problem? I'm having the opposite problem as you; Word XP is printing blank lines when data doesn't exist for a field, and I cannot figure out how to suppress the blank lines from printing.

I created a mail merge document using Word 2000 and (Excel 2000 as the data source). When I use Office 2000 to execute the merge, everything works fine. When I tried to open the document in Word XP and execute the merge, blank lines are showing up in the address for those entries that do not...

I'd thought of that. Is there a way to do it without having to use a template?

I have an Access database that creates Excel spreadsheets using VBA code. The spreadsheets are sent out to various people who add/update the data in the spreadsheet. The spreadsheets are then uploaded into the database using VBA code within Access. A new requirement has come up where when a...

Thanks, that worked great. Have a star on me!

Erase worked perfectly! You get a star, Phantazmo.

The above does not work. You cannot assign "nothing" to an array. Does anyone else know how to reset an array (clear out all values and make length 0)?

I have a report that allows the user to select certain criteria for the report. In the report's Open event, I open the criteria form in Dialog mode, so that the user has to make the selection. Here is the code: Private Sub Report_Open(Cancel As Integer) 'Open the form for date input...

Thanks! One purple star for you!

I have an Access database that contains code to generate Excel Workbooks/Sheets using information contained in the database. The generated spreadsheets have various formatting and protection features enabled. But what I can't figure out is how to freeze the panes in Excel from within the...

I am having the same problem. I have a sub form within a form. In the main form I have a combobox. The subform will display the information related to the value of the combo box. Whenever I select a value in the combobox that has no related info (a perfectly valid scenario), ALL controls go...