[AccessD] Mail Merge

Mark:

I read the post and switched to early binding but it didn't make any
difference.  Also substituted 0 for wdSendToNewDocument.  No soap.  Although
that seemed to work for the poster. :(

Rocky
 




 	
	

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Mark A Matte
Sent: Thursday, January 24, 2008 10:53 AM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Mail Merge


Rocky,

Below is a link discussing late binding and word automation.  It appears to
give a workaround for this type of issue about 1/4 down the page:
http://www.thescripts.com/forum/thread189594.html

***************SNIP******************
wdSendToNewDocument is a named constant or something like that. What if you
cheat and do something like

?wdSendToNewDocument

in the immediate window, get the number/value associated with this variable
and use that number instead? Does it work?"
***************SNIP******************

Good Luck,

Mark A. Matte

> From: rockysmolin at bchacc.com
> To: accessd at databaseadvisors.com
> Date: Thu, 24 Jan 2008 06:56:42 -0800
> Subject: [AccessD] Mail Merge
>
> Dear List:
>
> I'm still struggling with this word merge thing. The code I'm looking 
> at I thought was working previously. I cribbed it right out of 
> Balter's Mastering Access 97 Development. I'm using A2K3. No references
missing.
>
> It's not very much code. strDocName contains a valid document and it 
> actually opens:
>
>
> Dim objWord As Object
>
> Set objWord = CreateObject("Word.Application")
>
> With objWord
> 'Visible is set True in order to view the operation.
> .Visible = True
> .Documents.Open (strDocName)
> .ActiveDocument.MailMerge.Destination = wdSendToNewDocument 
> .ActiveDocument.MailMerge.SuppressBlankLines = True 
> .ActiveDocument.MailMerge.Execute End With
>
> It blows up on " .ActiveDocument.MailMerge.Destination = 
> wdSendToNewDocument" with an error "Requested Object is not Available".
>
> I've had this 'Object Not Available' problem before but due to my 
> advanced age cannot remember what the fix is.
>
> Does anyone have a hint why this is failing at that point?
>
> MTIA,
>
> Rocky
>
>
>
>
>
>
>
>
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Arthur 
> Fuller
> Sent: Wednesday, January 23, 2008 8:15 AM
> To: Access Developers discussion and problem solving
> Subject: Re: [AccessD] Mail Merge
>
> Helen Feddema's site has lots such things. Her specialty is Office 
> integration. Google will take you there quickly.
>
> A.
>
> On 1/23/08, Rocky Smolin at Beach Access Software
> wrote:
>>
>> Dear List:
>>
>> I need to do a simple Mail Merge Access-->Word and don't want to 
>> reinvent the wheel. Is there a canned routine on line that I could 
>> crib? I checked Lebans but didn't see anything.
>>
>> MTIA
>>
>> Rocky
>>
>>
>>
>>
>> --
>> AccessD mailing list
>> AccessD at databaseadvisors.com
>> http://databaseadvisors.com/mailman/listinfo/accessd
>> Website: http://www.databaseadvisors.com
>>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>
> No virus found in this incoming message.
> Checked by AVG Free Edition.
> Version: 7.5.516 / Virus Database: 269.19.8/1236 - Release Date: 
> 1/21/2008
> 8:23 PM
>
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com

_________________________________________________________________
Helping your favorite cause is as easy as instant messaging. You IM, we
give.
http://im.live.com/Messenger/IM/Home/?source=text_hotmail_join
--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

No virus found in this incoming message.
Checked by AVG Free Edition. 
Version: 7.5.516 / Virus Database: 269.19.10/1240 - Release Date: 1/23/2008
5:47 PM