473,564 Members | 2,759 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Word not opening properly during a mailmerge

When I do a mailmerge from Access to Word by automation, sometimes, the Word
window does not fully open and can be found up in the very top left hand
corner of the screen. Is there a command I can send with the automation
code to ensure that Word opens into a maximised window?

dixie
Nov 12 '05 #1
2 1937
"dixie" <di****@dogmail .com> wrote in message news:<YR******* *********@nnrp1 .ozemail.com.au >...
When I do a mailmerge from Access to Word by automation, sometimes, the Word
window does not fully open and can be found up in the very top left hand
corner of the screen. Is there a command I can send with the automation
code to ensure that Word opens into a maximised window?

dixie


something like... (UNTESTED snippet)

Public Sub MuckWithWord()
Dim appWord As Word.Applicatio n
Set appWord = New Word.Applicatio n

appWord.Activat e
appWord.ActiveW indow.WindowSta te = wdWindowStateMa ximize
End Sub
Nov 12 '05 #2
Now tested and functional. Thanks Pieter.

dixie

"Pieter Linden" <pi********@hot mail.com> wrote in message
news:bf******** *************** *@posting.googl e.com...
"dixie" <di****@dogmail .com> wrote in message

news:<YR******* *********@nnrp1 .ozemail.com.au >...
When I do a mailmerge from Access to Word by automation, sometimes, the Word window does not fully open and can be found up in the very top left hand
corner of the screen. Is there a command I can send with the automation
code to ensure that Word opens into a maximised window?

dixie


something like... (UNTESTED snippet)

Public Sub MuckWithWord()
Dim appWord As Word.Applicatio n
Set appWord = New Word.Applicatio n

appWord.Activat e
appWord.ActiveW indow.WindowSta te = wdWindowStateMa ximize
End Sub

Nov 12 '05 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
1286
by: Bud Zielinski | last post by:
Some of our users have converted to Office 2003. Our Access app is in 2000. they run it in Access 2003 with Access 2000 as the default file format. When doing a merge from the partial code segment below, we had rec'd the : "Opening this will run the following SQL Command" message. We were able to suppress that message with registry changes...
1
4929
by: svdh | last post by:
I have posed a question last saturday and have advanced alot in the meantime. But I am still not there Problem is that I try to merging various fields from various tables in one document in Word 1. Query..I want to keep the fields seperatred. I do not want to sent on field with all accumulated languages from one person to Word. Each...
4
7463
by: pmhaupt2 | last post by:
I developed an Access 2003 program that will allow the user to produce a group of Word letters that merge with data records from an Access database. I created a mail merge Word document and associated it with a specific query in my Access database. My problem is that when I run my "create letters" button from an Access form, the program...
10
26071
by: John | last post by:
Hi I am trying to do a word mailmerge form within my vb.net app. My problem is how to do a query on one of my tables and use the result as the mail merge datasource. Any help would be appreciated. Thanks Regards
2
13494
by: Mikey | last post by:
Sample VB .NET source code to create mailing labels or customized letters using MS Word MailMerge This VB .NET source code will start MS Word and call methods and set properties in MS Word to execute a MailMerge to create mailing labels or customized letters. A label name known to MS Word MailMerge mailing label wizard may be used or a...
2
3364
by: Colin Halliday | last post by:
I have a Word 2003 mail merge main document (form letter) that is linked to another Word document data source for the mail merge. If I open this doc using the Word GUI, it first asks me to confirm that I want to run a query to select the data from the data source file, then it opens the form letter fine. I can preview the merged records and...
4
7732
by: Willis Wilson | last post by:
Platform: Access 2003 SP2 and Windows XP. I've tried a number of different scenarios and none of them seem to work The "OpenDataSource" statement gives a Run-time error 5922. Please help find my error. '******************************************** Dim wdApp As Word.Application, wd As Word.Document, strConnection As String Set...
1
2116
by: =?Utf-8?B?QmFkaXM=?= | last post by:
Hi, I'm using the bellow code to mail merge a word document and it's working fine, where I'm openning "improvement.doc" which is just word document that contain with some text and the merge fields at the top of the document... after performing the merge I want to save the merged document as "merged.doc" and close it. the problem is that my...
3
4999
by: brat33 | last post by:
I am trying to use a command button to automate a process for creating mailing labels from a query in Access 2007, going into word 2007. Current code looks like the following: 'Start MS Word Dim objWord As Word.Application Set objWord = CreateObject("Word.Application") 'Make Application visible With objWord .Visible = True ...
0
7665
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main...
0
7888
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. ...
0
8106
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that...
0
7950
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the...
1
5484
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes...
0
5213
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert...
0
3626
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
1200
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
0
924
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.