I am running a macro to do a mail merge from an excel spreadsheet.
The code for the mail merge is as follows:
ActiveDocument.MailMerge.OpenDataSource Name:= _
       excelsheet, ConfirmConversions:=False, ReadOnly:= _

Hi group,
I will appreciate it if someobdy could give me some advice on Graphs!
How can I have stable charts? everything I do in code causes to see
different results in chart in terms of color, Y axis and ...? either

I have an textbox field for user entering date. But, I want to do date
validation. (i.e. if the input date is before or equal to Today date,
it will prompt a "Invalid inputted date" message) What commands I have
to use for the date comparision? Could anyone give me some hints on

Here is the problem I am having......
I am trying to automatically attach a file to an email in Outlook every
week...right now the file is attaching and going to my drafts in
outlook, which is perfect.

Just created some macros in Word....They open up Word templates that
are located on a server. Each office has its own server with the same
filepath....The only difference is the server name.
Template location

In order to save the users from answering the question if they want
to accept Macros for this current document, or if they want to live in
the fear of rogue macros, I would like to sign my VBA programs, so
that they can decide to trust my macros always and forever.

Hi all, I have a program which merges several word files in one. I basically
create a new empty document and using InsertFile (the same as Insert->File
from Word) I insert the other documents (with a page break between them). The
problem is that some formatting settings are changed. ...

Cross-posted from microsoft.public.word after a week with no responses:
Using Word 2002, is there any way to add a field that gives the
remaining days to a certain date? It does  not appear that DateDiff()
is a valid function for a formula in an inserted field. Right now, I

I want the first match in a string, which I do as follows -
Dim strArray As Variant
strArray = Split(str, Chr(10), 2)
then strArray stores my value (I only want the first string before my

I'm using a batch file "catff.bat" to concatenate a bunch of files.
Catff.bat is called from Word using the shell command, then the
concancatenated file is opened in Word and formatted.The problem is
that the Word macro tries to open the file before the batch file is

I have used a foundfiles object so that I can open all word documents within
a particular folder on a network drive.
I would like to now do a LIKE comparison on the files that have been found
against some string criteria as shown below :

I have some code - which until today - was working perfectly:
Sub AddPONo()
Order = System.PrivateProfileString("\\server\dept$\IT\New Purchase
Orders\Settings.Txt", _

I am new boy to the block, especially to Word VBA I am a new born.
This is the all time referenced solution by Doug Robbins created on
26/10/01 to updating ALL the links to Excel sources in a Word doc in
one simple step. I tried and the end result is that ALL links,

I would like to create a button using VB or create a macro that allow me to
click on it and will automatically send the Word file to multiple people with
different e-mail address.
Thanks. K

I'm having a problem updating the Table Of Contents in Word 2003.
I've tried stepping through all table of contents in the document and
running update but this only updates the page numbers and not the
actual structure of the table.  If I update the TOC manually it updates