start Outlook 2002 via Word 2002 macro

MS WORD

    Sponsored Links

    Next

  • 1. Using Image in macro
    I am using a macro to create labels from mail merge and then insert images in the labels depending upon the values of certain fields. When I want to deploy this macro to another m/c, I have to copy word doc, excel spreadsheet and the images that I am using. Is there a way to bundle the images in a resource file so that I deploy only 1 file and users are not able to get to the image files directly? Thanks
  • 2. is there an add-in for "open office" documents
    My daughters school has switched from "Microsoft Office" to "Open Office". I can't open the document sent from her teacher.
  • 3. VBA to change font of all table captions
    I am using forms in word2003 to create Report Cards. All the tables have the same fields with the same formfield names. I need to be able to change the font of all table captions under VBA control Thanks
  • 4. Multiple identical forms in one doc
    I am using forms in word2003 to create Report Cards. All the tables have the same fields with the same formfield names. I need to run macros on some of the fields. I have used absolute cell referencing such as: ' Row4, Col2 is the location of the field- Comment ActiveDocument.Tables(y).Cell(4, 2).Range.Text = CurrentComment but it deletes the field and replaces it with Protected (uneditable)text. So I manually renamed each Comment field Comment## where ## is the table number. All works OK with CASE structure. Ex: Case 7 ActiveDocument.FormFields("Comments7").Result = CurrentComment But the user can specify the number of tables needed so I need the renaming to be automatic. And there are other fields that need macros. Is manually renaming all macro-controlled fields the only solution? Thanks
  • 5. Distribute company-wide style change
    Our company has a desire to update over 100 employee computers with a style change in Word. I'm asking what is the best way to accomplish this? Programmatically or some other way? I can write programming to accomplish this on one computer, but I not aware of a way to distribute it to other computers. What other options might be better to consider? Thanks! -- Steve C

start Outlook 2002 via Word 2002 macro

Postby Heike Pertzel » Thu, 28 Jul 2005 16:50:56 GMT

Hallo!

I would like to check in a Word 2002 macro wether Outlook 2002 is running 
and if not to start it.
I've tried a lot of code I've found via internet but nothing worked 
correctly.
Has somebody any hint for me?

Thanks and regards
Heike Pertzel / DATA 5 GmbH




Re: start Outlook 2002 via Word 2002 macro

Postby Doug Robbins » Fri, 29 Jul 2005 05:59:57 GMT

The code in the article "Mail Merge to E-mail with Attachments" at

 http://www.**--****.com/ 

contains the necessary construction.


-- 
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my 
services on a paid consulting basis.

Doug Robbins - Word MVP







Re: start Outlook 2002 via Word 2002 macro

Postby Heike Pertzel » Fri, 29 Jul 2005 17:11:34 GMT

Hallo Doug Robbins,

thanks for the link. I could solve my problem.

Heike Pertzel / DATA 5 GmbH

"Doug Robbins" < XXXX@XXXXX.COM > schrieb im Newsbeitrag 








Similar Threads:

1.Automation Word 2002 - Outlook 2002

Hallo!

I would like to run a macro, which is saved in the Outlook file 
VbaProject.OTM in
Modul1, with Automation out of Word. What's the code for this?

Set OutAppl = CreateObject("Outlook.Application")
????

The other way round I can start from Outlook a macro, which is saved in any 
Word-DOT, with this code:

Set WordAppl = CreateObject("Word.Application")
WordAppl.Run "Projectname.Modulname.Macroname"

Unfortunately "Run" does not exist in Outlook.
Any help would be wonderfull!!!

Thanks!
Heike Pertzel / DATA 5 GmbH


2.Converting Word 9 Macros to Word 2002 Macros

Created extensive macros, automating laborious tasks, in 
Word 9 (or 2000) but we are using Word 2002 now and cannot 
open nor edit the macros in 2002.  Any way to accomplish 
this without resorting to rebuilding them in their 
entirety?  Macros will run, but need to be edited to 
reflect current operating conditions.  No copy of Word 
9/2000 exists since corporate upgraded.

Suggestions deeply appreciated.

3.Mail Merge Word 2002 via Outlook 2002 - HELP

Hello, I am trying to do a mail merge from Word 2002 to Outlook 2002 (e-mail 
list from Excel 2002).  I am doing this in HTML format.  The mail merge 
appears to work but the message never appears in my outbox or my sent box in 
Outlook.  If I change it to Plain Text, it does go but via the warning 
message.  

A friend of mine tried to send the same messge via Word 2003 and Outlook 
2003 and it works fine.  I don't have Word 2003 and Outlook 2003 and need to 
send out such an e-mail on a regular basis.  

Any idea of what may be wrong?

4.Word 2002 Mail Merge Error via Excel 2002, XP Op System

This only happens on one file. I received a download of data in an
excel file (same version I run, same op system I run) and saved the
original file and then saved a copy of the file under a new name and
sorted the data, split the data between 3 worksheets based on specific
criteria, applied general formating (col width, row height, color,
etc.).

I use the merge wizard in Word 2002, which I have done hundreds of
times. But this document is giving me intermittent problems. I follow
the below method.

Document Type: Letter
Start Document: Use the current doc
Select recipients: Browse
I select the copy of the original file
Select Table: I choose Sheet1$ from the following options: additional$,
approved$, dvo7lkup$, rejected$)

When the mail merge recipient window opens it is not populated with
Sheet1$ information it has sheet additional1$

I X out and go back to:

Select a different List
I select the same file (copy of the original file)
Now the Select Table has the following options: Sheet1$, Sheet2$,
Sheet3$, and so on.
I select Sheet1$ (I have selected them all in hopes of troubleshooting)
and the mail merge recipient window is blank.

If I close out and start over it is correct. But if I decide that I
need to tweak the data more and cancel the merge and come back later
the same thing happens again.

I tested the original doc and I do not get the errors. I checked to see
if there was code b/c there shouldn't be on a simple text doc. and
there isn't any code. the VBA is the same on the original as it is on
the copy. The original was sent from the same version of windows and op
system.

I cannot figure this out. I know just use the original but what if this
occurs again.

I would appreciate any insight anyone can give me. Thank you so much!

5.Follow up to Word 2002 Mail Merge Error via Excel 2002, XP Op System

Hi there and Thank you! Sorry for the delayed response got derailed 
for awhile.

OK, I followed your plan and have added the alpha characters to 
represent the character designators in the 1st response.

a. Saved the original as a .csv and started from scratch. It was 
tedious because you can only convert one sheet and not an entire 
workbook. Anyway, it seems to have worked. I am unable to recreate the 
error.

b. The .xls was closed when I made my initial inquiry. This time it 
was open and there were no problems. Should the .xls be closed before 
a merge? Sometimes I close the database and sometimes I don't.

c. I believe the data source was disconnected. Strange thing though, I 
would close all instances of excel and word. When I checked the task 
manager/processes it showed an instance of excel.exe still running. So 
I would end the process and start again. I checked the event viewer 
and there are no errors or warnings.

d. Yes, there is data in sheet1$ as well as additional$, approved$, 
dvo7lkup$, rejected$. It didn't matter which sheet I chose the data 
would be incorrect or absent.

Is there anyway to determine what corrupted the file?

Thanks again!

On Jan 25, 2:22 pm, "Peter Jamieson" < XXXX@XXXXX.COM > 
wrote:
> Some thoughts:
>  a. could the workbook you are receiving be corrupt? You could experiment by
> exporting its contents to .csv then importing to a fresh .xls create don
> your system, then proceed as you are already doing.
>  b. is the .xls closed when you try to connect to it?
>  c. do you disconnect the existing data source before connecting (even if it
> is the same workbook)? (e.g. use the MailMerge toolbar button 1 to set the
> document to "Normal Word document", which should do the disconnect. Then
> select the merge type you want and proceed with the connect.
>  d.
> <<
> Select Table: I choose Sheet1$ from the following options: additional$,
> approved$, dvo7lkup$, rejected$)
>
> Is there a "Sheet1"? Or do you choose sheet "additional" ? or what?
>
> (That's about as far as I can follow for now...)
>
> Peter Jamieson
>
> "Techy Wannabe" < XXXX@XXXXX.COM > wrote in messagenews: XXXX@XXXXX.COM ...
>
> > This only happens on one file. I received a download of data in an
> > excel file (same version I run, same op system I run) and saved the
> > original file and then saved a copy of the file under a new name and
> > sorted the data, split the data between 3 worksheets based on specific
> > criteria, applied general formating (col width, row height, color,
> > etc.).
>
> > I use the merge wizard in Word 2002, which I have done hundreds of
> > times. But this document is giving me intermittent problems. I follow
> > the below method.
>
> > Document Type: Letter
> > Start Document: Use the current doc
> > Select recipients: Browse
> > I select the copy of the original file
> > Select Table: I choose Sheet1$ from the following options: additional$,
> > approved$, dvo7lkup$, rejected$)
>
> > When the mail merge recipient window opens it is not populated with
> > Sheet1$ information it has sheet additional1$
>
> > I X out and go back to:
>
> > Select a different List
> > I select the same file (copy of the original file)
> > Now the Select Table has the following options: Sheet1$, Sheet2$,
> > Sheet3$, and so on.
> > I select Sheet1$ (I have selected them all in hopes of troubleshooting)
> > and the mail merge recipient window is blank.
>
> > If I close out and start over it is correct. But if I decide that I
> > need to tweak the data more and cancel the merge and come back later
> > the same thing happens again.
>
> > I tested the original doc and I do not get the errors. I checked to see
> > if there was code b/c there shouldn't be on a simple text doc. and
> > there isn't any code. the VBA is the same on the original as it is on
> > the copy. The original was sent from the same version of windows and op
> > system.
>
> > I cannot figure this out. I know just use the original but what if this
> > occurs again.
>
> > I would appreciate any insight anyone can give me. Thank you so much!

6. Word Macros / Normal.dot: Word 4.3/95->2002

7. Start Word 2002 from VB script

8. Starting MS Word 2002 from VB script



Return to MS WORD

 

Who is online

Users browsing this forum: No registered users and 99 guest