A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Word » Mailmerge
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Mail Merge & Protected Form (Doug Robbins Code)



 
 
Thread Tools Display Modes
  #1  
Old April 8th, 2010, 10:12 AM posted to microsoft.public.word.mailmerge.fields
Andy Roberts
external usenet poster
 
Posts: 183
Default Mail Merge & Protected Form (Doug Robbins Code)

I was pointed to Doug Robbins code at
(http://www.gmayor.com/Form_Fields_and_Mail_Merge.htm) which looks to do
exactly what I need however I'm getting an error when the macro runs which
is a 9 Subscript out of range error (see attached screenshot).

The scenario is that I have a form with quite a few tick boxes and text
fields in it but I want to populate the form title and address of the
recipient similar to Doug's Example. Once populated I then want to protect
the form and tick the relevant check boxes before printing etc (again
similar to Doug's example).

I have saved the form as a macro enabled word template, with an attached
data source and relevant mail merge fields in the correct places, plus my
checkboxes (the form is unprotected at this point as I can see the mail
merge results and word 2007 wont let you protect a form if it contains any
mail merge fields).

I then open a new document based on this template and manually run Doug's
code which prompts me for a password which I click OK for (and leave blank
as I don't need one). A couple of seconds later I get the subscript error
with no break in the code so I can't see where it is failing.

If I click ok to the error message and examine the document it seems to be
ok? Should I be seeing this error?

--
Regards

Andy

Andy Roberts
Win XP, Office 2007




  #2  
Old April 8th, 2010, 10:18 PM posted to microsoft.public.word.mailmerge.fields
Doug Robbins - Word MVP
external usenet poster
 
Posts: 8,239
Default Mail Merge & Protected Form (Doug Robbins Code)

Send a copy of the template to dkr[atsymbol]mvps[dot]org and I will have a
look at it.

--
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, originally posted via msnews.microsoft.com

"Andy Roberts" wrote in message
...
I was pointed to Doug Robbins code at
(http://www.gmayor.com/Form_Fields_and_Mail_Merge.htm) which looks to do
exactly what I need however I'm getting an error when the macro runs which
is a 9 Subscript out of range error (see attached screenshot).

The scenario is that I have a form with quite a few tick boxes and text
fields in it but I want to populate the form title and address of the
recipient similar to Doug's Example. Once populated I then want to
protect the form and tick the relevant check boxes before printing etc
(again similar to Doug's example).

I have saved the form as a macro enabled word template, with an attached
data source and relevant mail merge fields in the correct places, plus my
checkboxes (the form is unprotected at this point as I can see the mail
merge results and word 2007 wont let you protect a form if it contains any
mail merge fields).

I then open a new document based on this template and manually run Doug's
code which prompts me for a password which I click OK for (and leave blank
as I don't need one). A couple of seconds later I get the subscript error
with no break in the code so I can't see where it is failing.

If I click ok to the error message and examine the document it seems to be
ok? Should I be seeing this error?

--
Regards

Andy

Andy Roberts
Win XP, Office 2007


  #3  
Old April 9th, 2010, 10:05 AM posted to microsoft.public.word.mailmerge.fields
Andy Roberts
external usenet poster
 
Posts: 183
Default Mail Merge & Protected Form (Doug Robbins Code)

Thanks Doug

Email sent

--
Regards

Andy

Andy Roberts
Win XP, Office 2007
"Doug Robbins - Word MVP" wrote in message
...
Send a copy of the template to dkr[atsymbol]mvps[dot]org and I will have a
look at it.

--
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, originally posted via msnews.microsoft.com

"Andy Roberts" wrote in message
...
I was pointed to Doug Robbins code at
(http://www.gmayor.com/Form_Fields_and_Mail_Merge.htm) which looks to do
exactly what I need however I'm getting an error when the macro runs
which is a 9 Subscript out of range error (see attached screenshot).

The scenario is that I have a form with quite a few tick boxes and text
fields in it but I want to populate the form title and address of the
recipient similar to Doug's Example. Once populated I then want to
protect the form and tick the relevant check boxes before printing etc
(again similar to Doug's example).

I have saved the form as a macro enabled word template, with an attached
data source and relevant mail merge fields in the correct places, plus my
checkboxes (the form is unprotected at this point as I can see the mail
merge results and word 2007 wont let you protect a form if it contains
any mail merge fields).

I then open a new document based on this template and manually run Doug's
code which prompts me for a password which I click OK for (and leave
blank as I don't need one). A couple of seconds later I get the
subscript error with no break in the code so I can't see where it is
failing.

If I click ok to the error message and examine the document it seems to
be ok? Should I be seeing this error?

--
Regards

Andy

Andy Roberts
Win XP, Office 2007




  #4  
Old April 9th, 2010, 10:33 AM posted to microsoft.public.word.mailmerge.fields
Graham Mayor
external usenet poster
 
Posts: 18,297
Default Mail Merge & Protected Form (Doug Robbins Code)

Doug
Can you cc the feedback to me please?

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org



"Doug Robbins - Word MVP" wrote in message
...
Send a copy of the template to dkr[atsymbol]mvps[dot]org and I will have a
look at it.

--
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, originally posted via msnews.microsoft.com

"Andy Roberts" wrote in message
...
I was pointed to Doug Robbins code at
(http://www.gmayor.com/Form_Fields_and_Mail_Merge.htm) which looks to do
exactly what I need however I'm getting an error when the macro runs
which is a 9 Subscript out of range error (see attached screenshot).

The scenario is that I have a form with quite a few tick boxes and text
fields in it but I want to populate the form title and address of the
recipient similar to Doug's Example. Once populated I then want to
protect the form and tick the relevant check boxes before printing etc
(again similar to Doug's example).

I have saved the form as a macro enabled word template, with an attached
data source and relevant mail merge fields in the correct places, plus my
checkboxes (the form is unprotected at this point as I can see the mail
merge results and word 2007 wont let you protect a form if it contains
any mail merge fields).

I then open a new document based on this template and manually run Doug's
code which prompts me for a password which I click OK for (and leave
blank as I don't need one). A couple of seconds later I get the
subscript error with no break in the code so I can't see where it is
failing.

If I click ok to the error message and examine the document it seems to
be ok? Should I be seeing this error?

--
Regards

Andy

Andy Roberts
Win XP, Office 2007




 




Thread Tools
Display Modes

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

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 07:05 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.