Word VBA >> Canned responses/mail integration

by bWlzdHk » Tue, 10 Aug 2004 09:57:02 GMT

I've seen this done before, but it's been a long time. I'm doing a fair
amount of email support and easily accessible canned responses would make the
entire process oodles easier. I'm using Outlook for mail management, but
I've seen canned responses that could be set up, organized, and selected
within Word to create the email and then simply copied and paste to be sent
out through Outlook. Anyone know how I can create and organize canned
responses within Word? I'm a novice when it comes to it, but surely it can't
be that hard.

It's either this, my little folders full of text files that aren't nearly as
convenient and limit productivity, or I somehow manage to convince management
to actually purchase an email database system that could support this, but
that would actually be overkill for our needs.


Word VBA >> Canned responses/mail integration

by Jezebel » Tue, 10 Aug 2004 10:20:40 GMT


Experiment with AutoText. It's not the only way, but probably the best for
your purposes if you want to use Word.

A simpler method, using Outlook only, is to use signatures. You can put any
amount of text into a signature (and graphics, too, if you use HTML). Create
a separate signature for each canned response: from within Outlook, you can
create and send your canned reply in four clicks.






the
sent
can't
as
management





Similar Threads

1. CORRECTION: Deleting copies of mail items without sending ReadReceiptRequest response

2. VBA to reply to mail and type standard response

I'd like a pointer how to get VBA to create a reply to the selected
email and insert a standard text message at the top of the reply.

Any help would be appreciated, I am a good coder but can't seem to get
started with this.

Using Outlook 2002, HELP!

3. Deleting copies of mail items without sending ReadReceiptRequest response

4. Access/Word integration Mail Merge issue

I'm automating an Access database.  One of the functions that it must perform 
is to print out envelopes to certain addresses stored in the database.  I've 
put the code below into a command button, but when it is run, several dialog 
boxes come up, specifically "Data Link Properties", "Confirm Data Source" and 
"Log In".

This is unacceptable.  The point of automation is to prevent the user from 
having to make choices like this, especially such abstruse ones that will not 
make the slightest bit of sense to most of my end-users.

Further, it just shouldn't happen, since most of the choices being asked of 
the user have already been indicated in the code, so obviously I'm doing 
something incorrectly.

Any help would be appreciated.

(Also, tell me if I'm posting this to the wrong forum, the groups here 
aren't always clearly delineated.)

Private Sub cmdPrintEnvelopes_Click()
    Dim WordApp As Word.Application
    Dim WordDoc As Word.Document
    
    Set WordApp = CreateObject("Word.Application")
    WordApp.Visible = True
    Set WordDoc = WordApp.Documents.Open(Application.CurrentProject.Path & 
"\envelopes.doc", , True, False, , , , , , , , True)
    
    With WordDoc.MailMerge
        .Destination = wdSendToPrinter
        .OpenDataSource _
                Name:=Application.CurrentProject.FullName, _
                ReadOnly:=True, _
                LinkToSource:=False, _
                AddToRecentFiles:=False, _
                PasswordDocument:="EZ4ME", _
                Revert:=False, _
                Connection:="QUERY Envelopes"
        
        .Execute
    End With
    
    WordDoc.Close False
    WordApp.Quit wdDoNotSaveChanges
End Sub

5. Windows Mail Integration with Office 2007 Home and Student - MS Office Setup

6. Macro to insert file, pause, get response, act on response

I'm trying to write a macro which will insert a file (varying files from a 
document management system - Imanage), pause and wait for the user to input 
the document number and then act on the user's response.  Can't seem to get 
that code using the Macro Recorder in Word - don't know how to tell it to 
pause and wait for a response from the user.  Any help would be appreciated.

7. Canned VBA Date Validation - Excel

8. How can I call a canned visual basic program from LabVIEW 6.1 and 7.1

I have a Visual Basic program written by the temperature controller
vendor. I wish to use it to control the enviornmental chambers. The
plan is to to call this program from LabVIEW utalize it to control the
enviornmental chambers and collect the data. When the program is
complete return to LabVIEW and use it to utalize the data it gathers.

The problem I have is calling the program, can anyone help.