Replies

There is a time element involved. If I change the printer to duplex all the time, each single page print job is passed through the printer as if there were more than one sheet; this is time consuming and does not make sense to print single pages this way.

Thanks…it works.

Fafner,

I am using the “with specific words in the sender’s address”. If the specific word is “Microsoft” and the email message comes from XXXX_XXXXX@microsoft.com I should be able to move the message to a folder named “MSoft”. If this is so, I can not get it to work.

What I would like to do is establish rules for various email messages received from ?.Com and have it moved upon receipt to a specific folder of choice.

I accomplished this in Word97 using an XL file and the mail merge feature. You should have the capability of doing it in Access using Office 2000. The navagation in Word97 is Tools>Mail Merge: You have 3 steps to complete, the first being creating the mail merge word doc, the second indicates what data source your using (in your case Access) and the third and final step to merge the information and email the file to a recipient. Your Access database should include the email address of the various individuals. In step 3 under Options, you have to change how the merged file is to be sent ie email.

I do not have Office 2000 but the concept should be the same. You can send a message with a subject and an attached word doc (the mail merged doc).

I was using Woody as an example. However I receive email from numerous sources which I would like to move to various folders. A better example would be “Microsoft”. If the source orginated from Microsoft, the message would move to a folder named “Bill”. Either way the wizard does not appear to work.

It works, thank you.

Have you tried the drop-down option: File->Print
and then checked the box for print-to-file

I am trying to write a custom function in VBA code.

It works.

Thank you,
John

Thank you. The array formula did the trick.

Another way would be to assign a range name to the cell in each workbook ie you don’t have to worry about inserting rows or columns.

Modifying Tony55’s code:
To reference a cell from a different workbook use something like this:
=’C:My Documents[Filename.xls]Sheet1′!YourRangeName

Edited by WebGenii on 16-Aug-01 21:48.

Microsoft has a tool to recover a damaged XL 97 file. I believe the KB reference is Q142117-Summary of methods to recover data from corrupted files. I have used it and it does recover all range names, formulas, data, code and etc.. It may be worth your time to recover the XL file and then Zip the recovered file.

Legare,

Thank you for the advice. It works. Although it should work for “VLookup” I get an error message of “Unable to get the VLookup property of the worksheet function class”. According to the wsfunction class VLookup should work. Any ideas?

I’m using it in the following code:

Sub go()
Var1 = 15
Range(“A1”).Value = Application.WorksheetFunction.Vlookup(Var1,Table,2,false)
End Sub

Legare,

Is it possible to pass an XL file name into an array formula.

Such as:
Cell A1 = 1234.xls
Cell B1=INDEX(E:Hold&A1&’!RangeName,5)

The result would be INDEX(E:Hold1234.xls’!RangeName,5). This formula works but I can’t seem to pass the cell reference.

JS

Legare,

You’re correct.

INDEX(array,row_num,column_num) returns the value of a specified cell or array of cells within array.

Thanks,
JS