bcm, Any VBA script available for Help Desk type of use

1. "Outlook 97/98 Help Desk Form" using Outlook 2002

2. Word 2003 VBA Help not available in VB 6

3. Using excel workbooks from an outlook vba script

4. Creating/Using VBA Script to Convert Work 2000 wps to Word 2003 do

Hi,

     I'm a .NET software developer upgrading my mother's PC from Works 2000 
to Word 2003.  She has several hundred files in Word that I would like to 
convert in an automated script.  Right now, I only have her PC which has 
Works 2000 and Word 2003.  I was thinking/hoping that I could code a VBA 
script that would traverse through a directory of .wps, convert each file to 
a .doc file, and output the file to a separate directory.  I'm not that 
familiar with VBA, but I thought I would start by recording a macro in Word 
2003 that opens a .wps file and saves it as a Word .doc.  Any help on some 
example VBA scripts, or maybe a script that has already been created would be 
most appreciated.  I've seen converters out in the newgroups, but they all 
appear to be for single file conversion.  If anyone has some tips on 
performing a batch conversion, that would be great.  If someone feels this 
would be rather difficult in VBA, and much easier in .NET, I could always 
wait till I get access to my own PC.

Thanks,

Dave

5. Creating/Using VBA Script to Convert Work 2000 wps to Word 200

6. Selective Read Receipts VBA using run a script rule

Hello,

I'm running Outlook 2003 and would like the ability to always allow read 
receipts from the users in my address book, but would like to choose whether 
to allow a read receipt or not from anyone else. I'm attempting to do this by 
setting the outlook settings to "always allow", but run the following a rule 
on all incoming emails not in my contact list:

Sub PromptReadReceipt(MyMail As MailItem)
    Dim strID, Display, Title As String
    Dim olNS As Outlook.NameSpace
    Dim Msg As Outlook.MailItem
    Dim Style, Response
    
    Display = "Do you wish to allow a read receipt?"    ' Define message.
    Style = vbYesNo    ' Define buttons.
    Title = "Read Receipt Prompt"    ' Define title.
    
    strID = MyMail.EntryID
    Set olNS = Application.GetNamespace("MAPI")
    Set Msg = olNS.GetItemFromID(strID)
    If Item.ReadReceiptRequested = True Then
        Response = Msgbox(Display, Style, Title)
        If Response = vbNo Then
            Item.ReadReceiptRequested = False
            Item.OriginatorDeliveryReportRequested = False
            Item.Update
            End If
        Else
            End If
    Else
        End If
        
    Set Msg = Nothing
    Set olNS = Nothing
End Sub

I'm not very familiar with outlook and it's VBA code requirements, so I 
Frankensteined this from code I found on multiple web pages and help menus. I 
was hoping someone more experienced than I could have a look for errors/loops 
before I try this out in Outlook.

Thanks!

7. how to blocked spam in outlook 2003 using a VBA or macro script - Word VBA

8. Need help to create a macro or vba script to export data from exce

Waitign an answer, I move slowly. Now I am abble to create my filter and 
select the cells to export.
I temporarly put them in the clipboard.  But I actually want to save them in 
txt file
(When you paste it in notepad, it is TAB delimited. I want the same thing in 
a file.)



Sub MacroTestExport()
'
    Selection.AutoFilter Field:=4, Criteria1:="CDCAM"
    Selection.AutoFilter Field:=15, Criteria1:="<>DEL", Operator:=xlAnd, _
        Criteria2:="<>del"
    Range("A1:N1000").Select
    Selection.Copy
End Sub


-- 
Thank you.

Yann.
IXIS Asset Management Global Associates


"Yann de Champlain" wrote:

> Hi,
> 
> I Need help to create a macro or a VBA script to export data from excel.
> 
> There are around 15 columns.  I need to cerate a filter on two of these 
> columns.
> Then, I need to export 14 of the 15 columns to a TAB delimited file. (.txt).
> 
> I'd like it to work using a button in the sheet itself or something like that.
> 
> I have not idea how to perform these tasks.
> 
> In a second task, I would need to send a mail from the same script.
> 
> -- 
> Thank you.
> 
> Yann.
> IXIS Asset Management Global Associates