Results 1 to 7 of 7
  1. #1
    4 Star Lounger
    Join Date
    Aug 2003
    Location
    Stroud, United Kingdom
    Posts
    548
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Macrobutton x2 (XP)

    Hi,

    I am wanting to have a 2 macrobutton fields on my form, namely FileSave, and DocClose. Is there any way of putting these two macrobutton fields together so that the user only has to double click on what appears to be one field, rather than click one, then click the other (as I have now!)

    Thanks

    As a sideline, there really seems to be minimal help on all the macrobutton fields, both in MS and any other google... I don't suppose anyone has an abundant resource that details the finer points of MailAsHTML and all the others <img src=/S/doh.gif border=0 alt=doh width=15 height=15>
    Thanks,

    pmatz

  2. #2
    Plutonium Lounger
    Join Date
    Nov 2001
    Posts
    10,550
    Thanks
    0
    Thanked 7 Times in 7 Posts

    Re: Macrobutton x2 (XP)

    M

  3. #3
    4 Star Lounger
    Join Date
    Aug 2003
    Location
    Stroud, United Kingdom
    Posts
    548
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Macrobutton x2 (XP)

    Thanks StuartR

    would that then mean though that the user would get the 'Enable/Disable Macro' prompt?
    Thanks,

    pmatz

  4. #4
    Plutonium Lounger
    Join Date
    Nov 2001
    Posts
    10,550
    Thanks
    0
    Thanked 7 Times in 7 Posts

    Re: Macrobutton x2 (XP)

    Depending on the level of security they have chosen, yes.

    What is the environment that you will be distributing this to?
    Could you deploy a global template or does the code need to be in the document?

    StuartR

  5. #5
    4 Star Lounger
    Join Date
    Aug 2003
    Location
    Stroud, United Kingdom
    Posts
    548
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Macrobutton x2 (XP)

    Ok, what I have been saked to do is provide a shortcut on every users desktop which will open a form which after being filled in, will automatically send to a set list of recipients.

    Pretty simple in theory.

    I was thinking of a .oft file which is set up with recipients / subject etc, and with the attachment enclosed. Then the shortcut could point to that which would reside on the server.
    I will code the outlook template to fire the attachment when it is opened, which would be this Word form. Upon form completion, was going to have a filesave and close (without annoying macro prompts) which would then leave the email form with the amended attachement, all the user would have to do would be press Send.

    I am also looking at desgining a VB App to do all this, perhaps interfacing with a database.

    Also looking at how I could do this with a web based app.
    Thanks,

    pmatz

  6. #6
    Plutonium Lounger
    Join Date
    Nov 2001
    Posts
    10,550
    Thanks
    0
    Thanked 7 Times in 7 Posts

    Re: Macrobutton x2 (XP)

    Two ways you could avoid the prompts for Macros (assuming that your default Macro security is set to Medium or High, with trust installed add-ins).
    1. <LI>Put the simple macro into a global template that is placed in each users Word Startup folder, this could be very easy if you already maintain other Macros for the users, and may be worth doing anyway as if it will make future Macro deployment easier.
      <LI>Don't bother with the FileSave, just use FileClose. If the user hasn't already saved the document this will prompt them to save it anyway
    StuartR

  7. #7
    4 Star Lounger
    Join Date
    Aug 2003
    Location
    Stroud, United Kingdom
    Posts
    548
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Macrobutton x2 (XP)

    Thanks for the idea of the template in the user's startup folder! that may come in handy...
    Thanks,

    pmatz

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •