Web Toolbar

[Noel]

Hi, I posted this yesterday but it has not appeared yet.
Sorry if I double post. I tried posting on the Access
newsgroup without success.

I have used a hyperlink address on an Access database
command button to open a Mail Merge document. When it
opens a Web Toolbar opens also and this remains at the top
of the database window when Word is closed. The users then
have to close it manually. Is there a way to stop this
toolbar opening in the first place or if not, is there a
way to get it to close when Word is closed. Thanks, Noel

 

[Jay Freedman]

Hi, Noel,

See http://www.mvps.org/word/FAQs/MacrosVBA/BanishWebToolbar.htm.

 

[Noel]

Thank you Jay. One more question though. Where do I put
the code - in Word or in the database? Both are accessed
over a network so I can put Macros in the database itself
but Im sure I wont be able to do that in Word.(Or do I
embed it somehow in each of the Mail Merge documents?)
Cheers, Noel

 

[Suzanne S. Barnhill]

See http://www.gmayor.dsl.pipex.com/installing_macro.htm

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
Word MVP FAQ site: http://www.mvps.org/word
Email cannot be acknowledged; please post all follow-ups to the newsgroup so
all may benefit.

 

[Noel]

Thank You. Cheers, Noel

-----Original Message-----
See http://www.gmayor.dsl.pipex.com/installing_macro.htm

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
Word MVP FAQ site: http://www.mvps.org/word
Email cannot be acknowledged; please post all follow-ups to the newsgroup so
all may benefit.



.

 

[Noel]

Hi again - I posted this separately but thought Id post
here too. Ive tried putting the suggested code in a macro
in one of my Mail Merge documents but it doesnt work. Now,
even when I take the code out, I get an annoying warning
about the macro being present and continue only if certain
its from a virus free source. I cant win here, I try to
get rid of a toolbar and now Ive got both the toolbar and
a warning message about a Macro thats no longer there. Any
ideas please? Thanks, Noel

 

[Jay Freedman]

Hi, Noel,

I answered your other post before I saw this one. Please try to keep all
related posts in the same thread -- it will save time for both of us.

As I said in the other answer, you should put the macro in a template, not
in the mail merge document; and you have to run it manually (from the Tools

Macro > Macros dialog) before it will have any effect.

To clean out your merge document, open it in Word and use File > Save As,
change the "Save as type" box at the bottom to "Rich text format (*.rtf)",
and save to a temporary name of your choice. Close the document. Now open
the RTF file in Word, go to File > Save As again, change the type to "Word
document (*.doc)", and save to the original file name. Say yes when asked
whether to overwrite the old file. Because RTF doesn't support macros, this
process will clean the document.

 

[Noel]

Thanks Jay. Sorry for messing you about. This info just
what I need. Cheers, Noel