Birmangirl
Tue Aug 15 09:10:02 CDT 2006
Thank you Jay for the last piece "of the jigsaw" - everything is working
perfectly now and at last I can put this template to bed :)
Cheers
Amanda
"Jay Freedman" wrote:
> Sorry, I didn't read the quoted message preceding the one I responded
> to, and missed the question about Enter in a text field. Again, the
> answer is simple: In the userform editor, select the text box. If the
> Properties pane isn't visible, press F4 to display it. Find the
> EnterKeyBehavior and MultiLine properties and set both of them to
> True.
>
> --
> Regards,
> Jay Freedman
> Microsoft Word MVP FAQ:
http://word.mvps.org
> Email cannot be acknowledged; please post all follow-ups to the
> newsgroup so all may benefit.
>
> On Tue, 15 Aug 2006 00:53:02 -0700, Birmangirl
> <Birmangirl@discussions.microsoft.com> wrote:
>
> >Thanks for your response Jay - this has solved my problem :)
> >The only query I still have is the one of using one field for the full
> >name/address. If I use separate fields, I'll have the issue of having to
> >suppress blank lines.
> >If this is the only way around the problem, then so be it - but if there's a
> >better way, I'd love to know...
> >
> >TIA
> >Amanda
> >
> >"Jay Freedman" wrote:
> >
> >> The code you have *always* inserts text in addition to whatever is
> >> already in the bookmark. It works out ok if the bookmark contains one
> >> space character and nothing else, because you usually want a space
> >> after the inserted text. But if there's already text there and you
> >> want to replace it, you have to use a different command,
> >>
> >> .Bookmarks("NameAddress").Range.Text = NameAddress
> >>
> >> Besides replacing the existing text, that command will also destroy
> >> the bookmark. If you expect to need the bookmark afterward for
> >> anything (such as replacing its contents again), you have to re-insert
> >> the bookmark. See
> >>
http://www.word.mvps.org/FAQs/MacrosVBA/InsertingTextAtBookmark.htm
> >> for sample code.
> >>
> >> --
> >> Regards,
> >> Jay Freedman
> >> Microsoft Word MVP FAQ:
http://word.mvps.org
> >> Email cannot be acknowledged; please post all follow-ups to the
> >> newsgroup so all may benefit.
> >>
> >> On Mon, 14 Aug 2006 08:19:01 -0700, Birmangirl
> >> <Birmangirl@discussions.microsoft.com> wrote:
> >>
> >> >I believe I'm almost there. Instead of replacing the bookmark names with the
> >> >entered text, it is appending the text instead. This is a one-line sample for
> >> >one of the bookmarks - can anyone LMK what I'm doing wrong?
> >> >
> >> >.Bookmarks("NameAddress").Range.InsertBefore NameAddress
> >> >
> >> >TIA
> >> >Amanda
> >> >
> >> >"Birmangirl" wrote:
> >> >
> >> >> Everything is (almost) working and makes sense, except for Point 10) in the
> >> >> UserForm FAQs. I have 7 named bookmarks - could someone clarify what should
> >> >> be entered following the .Range_ instruction? I know this part is at fault in
> >> >> my template, as the debugger highlights it...
> >> >> Also, I have created a text box large enough for a recipient's name and
> >> >> address in full for the letter. When I press Enter, the cursor advances to
> >> >> the next field, not a new line. Do I need to create separate boxes for each
> >> >> name/address line?
> >> >>
> >> >> TIA and thanks for your patience and answers.
> >> >> Amanda
> >> >>
> >> >> "Doug Robbins - Word MVP" wrote:
> >> >>
> >> >> > You don't need a section break. Make use of the different first page option
> >> >> > on the Layout tab of the File>Page Setup Dialog.
> >> >> >
> >> >> > Have each user's template in their User templates folder.
> >> >> >
> >> >> > --
> >> >> > 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
> >> >> >
> >> >> > "Birmangirl" <Birmangirl@discussions.microsoft.com> wrote in message
> >> >> > news:B1CDA08E-5318-4913-AF4B-ECE1FE7645A6@microsoft.com...
> >> >> > >I appreciate your advice about forms; however, a couple of other questions
> >> >> > > before I go down that route:
> >> >> > >
> >> >> > > a) Our current template margins allow for a logo at the top on page one.
> >> >> > > If
> >> >> > > the letter continues on to a second page, would it be possible to allow
> >> >> > > for a
> >> >> > > different top margin on second and subsequent pages, i.e.
> >> >> > > IF(totalnumberofpages>1,THEN add a section break and make the top margin
> >> >> > > for
> >> >> > > section 2 = 1 inch,ELSE ignore).
> >> >> > >
> >> >> > > b) Our Administrators each work for a number of users. They want to
> >> >> > > customise their letterheads for each user. Is it possible to add each
> >> >> > > user's
> >> >> > > template to a menu (either as an item or from a submenu)?
> >> >> > >
> >> >> > > Sorry for all these questions but thanks everyone for the help so far.
> >> >> > >
> >> >> > > Amanda
> >> >> > > "Greg Maxey" wrote:
> >> >> > >
> >> >> > >> No. Yuo would have to insert another section break after the free text
> >> >> > >> section. I think a better approach would be a userform.
> >> >> > >>
> >> >> > >> To get started, see:
> >> >> > >>
http://word.mvps.org/FAQs/Userforms/CreateAUserForm.htm
> >> >> > >> Birmangirl wrote:
> >> >> > >> > Thanks for the response. Will this still work if my fillin fields are
> >> >> > >> > all
> >> >> > >> > over the place - they aren't conveniently all at the top of the letter
> >> >> > >> > template; some of necessity have to be at the end of the letter.
> >> >> > >> > I haven't set the template up as a form BTW.
> >> >> > >> > Ideally, once all the fillin fields are popilated, i'd just like Word
> >> >> > >> > to
> >> >> > >> > place the inswrtion point in the right place, ready to go - with no
> >> >> > >> > further
> >> >> > >> > user intervention.
> >> >> > >> >
> >> >> > >> > TIA
> >> >> > >> > Amanda
> >> >> > >> >
> >> >> > >> > "Jezebel" wrote:
> >> >> > >> >
> >> >> > >> > > Put a section break after the formfield section; protect only the
> >> >> > >> > > first
> >> >> > >> > > section, and let the users do as they will in section 2.
> >> >> > >> > >
> >> >> > >> > >
> >> >> > >> > >
> >> >> > >> > > "Birmangirl" <Birmangirl@discussions.microsoft.com> wrote in message
> >> >> > >> > > news:58A25F5B-12DA-417F-A925-C48670423C15@microsoft.com...
> >> >> > >> > > >I have a letter template, complete with fillin fields for
> >> >> > >> > > >name/address,
> >> >> > >> > > > subject, salutation etc which all works fine.
> >> >> > >> > > > When it comes to completing the body of the letter, I'd prefer NOT
> >> >> > >> > > > to use
> >> >> > >> > > > a
> >> >> > >> > > > fillin field, but to perhaps automatically move the cursor to the
> >> >> > >> > > > correct
> >> >> > >> > > > point once all fillin fields have been completed.
> >> >> > >> > > > Is there another field I could use, perhaps witha bookmark?
> >> >> > >> > > > Any suggestion gratefully accepted.
> >> >> > >> > > >
> >> >> > >> > > > TIA
> >> >> > >> > > > Amanda
> >> >> > >> > >
> >> >> > >> > >
> >> >> > >> > >
> >> >> > >>
> >> >> > >>
> >> >> >
> >> >> >
> >> >> >
> >>
>