[AccessD] Mail Merge

Rocky Smolin at Beach Access Software rockysmolin at bchacc.com
Thu Jan 24 15:22:28 CST 2008


I ain't afraid o' no registry. But I tried that one too with no luck. 

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 12:33 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Mail Merge


Ok...Are we up for some Registry Hacking?  It is the last post on the
page(even though it says members only...just scroll down)...good luck.

Mark

P.S...NO WARRANTY...I just found it...passed it on...have NOT tried
it...just sharing.


New link:
http://www.experts-exchange.com/Programming/Languages/Visual_Basic/Q_2290195
6.html


******************link snip************* DCrats:The problem is resolved...
This is what I had to do:

The document is linked to a data source....and I got this message when I
open the document in word. You receive the "Opening this will run the
following SQL command" message when you open a Word mail merge main document
that is linked to a data source


Word 2007
HKEY_CURRENT_USER\Software\Microsoft\Office\12.0\Word\Options 

"SQLSecurityCheck"=dword:00000000
1. Start Registry Editor. 
2. Locate and then click the following registry key:
HKEY_CURRENT_USER\Software\Microsoft\Office\12.0\Word\Options
3. On the Edit menu, point to New, and then click DWORD Value. 
4. Under Name, type:
SQLSecurityCheck
5. Double-click SQLSecurityCheck. 
6. In the Value data box, type: 
00000000
7. Click OK. 
******************link snip*************

> From: rockysmolin at bchacc.com
> To: accessd at databaseadvisors.com
> Date: Thu, 24 Jan 2008 11:32:33 -0800
> Subject: Re: [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
>
>
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com

_________________________________________________________________
Need to know the score, the latest news, or you need your HotmailR-get your
"fix".
http://www.msnmobilefix.com/Default.aspx
--
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
 




More information about the AccessD mailing list