PC Review


Reply
Thread Tools Rate Thread

Re: Mail merge with Access 2007 and WIF file Options

 
 
Doug Robbins - Word MVP
Guest
Posts: n/a
 
      23rd Apr 2008
I think that it might be more appropriate to post about the problem to an
Access newsgroup so I am cross-posting this response to
microsoft.public.access.security. Hopefully one of the experts there will
come up with a solution.

--
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

"stapes" <(E-Mail Removed)> wrote in message
news:04dccc01-196a-4228-94d1-(E-Mail Removed)...
> On 22 Apr, 20:44, "Doug Robbins - Word MVP" <d...@REMOVECAPSmvps.org>
> wrote:
>> Get around the issue by customizing the Quick Access Toolbar in Access to
>> add the Merge it with Microsoft Office Word button from the "Commands Not
>> in
>> the Ribbon" or "All Commands" group of the Choose commands from pulldown.
>>
>> To do this, you click on the Office button and then on Access Options in
>> the
>> bottom of the dialog and then on Customize.
>>
>> --
>> 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
>>
>> "stapes" <steve.sta...@gmail.com> wrote in message
>>
>> news:706adf1e-f9cd-482f-8f68-(E-Mail Removed)...
>>
>>
>>
>> > Hi

>>
>> > I am trying to run a mail merge using Word 2007, Access 2007, and a
>> > database with User level security using a workgroup information file.
>> > I have got as far as trying to Select Recipients. Where and how do I
>> > specify the Workgroup Information File?

>>
>> > I am looking at a Data Link Properties dialog box (from the Word Mail
>> > Merge). It has a field for the datasource, which is set to :
>> > C:\Projects\AC Global\Secure DB\SCOPSdb1.mdb

>>
>> > Below that, I have ticked the box Use a specific user name and
>> > password, and supplied those.

>>
>> > When I click the Test Connection button, it just says that the
>> > Workgroup Information File is missing.

>>
>> > How do I do it?

>>
>> > Stapes- Hide quoted text -

>>
>> - Show quoted text -

>
> Hi
>
> This solution brings up an error as word loads:
>
> You do not have the necessary permissions to use the 'C:\Projects\AC
> Global\Secure DB\SCOPSdb1.mdb' object. Have your system administrator
> or the person who created establish the appropriate permissions for
> you.
>
> I am logged in as the Admin user, and have all the permissions set for
> the table I am trying to Merge.
>
> Stapes



 
Reply With Quote
 
 
 
 
Stapes
Guest
Posts: n/a
 
      27th May 2008
I solved this problem in the end by doing it all within access. I added a
table called letters, for the user to add any number of mailshots. The
preview button then runs it against the Customer table.
 
Reply With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Access 2007 - Mail Merge with Word 2007 Kim Hurteau General Software 0 28th Sep 2011 11:20 PM
Access 2007/Word 2007 Mail Merge Opens Second Instance btibbet Microsoft Access 2 27th May 2010 08:24 PM
Access 2007 - Word 2007 - Mail Merge patkung Microsoft Access Form Coding 1 28th Jul 2009 03:35 PM
Word 2007, Access 2007 mail merge with Workgroup Information FileOptions Stapes Microsoft Access 0 22nd Apr 2008 06:46 PM
Word 2007, Access 2007 mail merge with Workgroup Information File Stapes Microsoft Access 0 18th Apr 2008 04:36 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 11:55 PM.