Results 1 to 4 of 4
  1. #1
    Triscia is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Sep 2013
    Posts
    8

    Manually record a macro


    I know that in previous versions of Access you could record you own macro by what you were clicking, it doesn't seem that 2010 does this. I want a Macro to automatically send an e-mail message. I got the macro to open the Manage Replies menu, but I need it to select all the next appropriate steps, like the following. Once it opens the Manage Replies, it will automatically select Resend this e-mail message, automatically select Next, automatically select from the drop down list a specific group, automatically select Next, repeat that step and repest it again and then automatically send the message. Is that even possible? TIA!

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,902
    Never heard of Access macro recorder. That is an Excel and Word (and maybe with other Office apps) feature.

    What you want is best accomplished with VBA. There are many threads on this topic, including this recent one: https://www.accessforums.net/program...nly-38170.html
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    Missinglinq's Avatar
    Missinglinq is offline VIP
    Windows 7 64bit Access 2007
    Join Date
    May 2012
    Location
    Richmond (Virginia, not North Yorkshire!)
    Posts
    3,018
    June7 is correct. There's never been a Macro record in Access. There may be a commercial add-in that will do it, but I'd be leery of it, to be honest. There's simply not enough call for one, because very few experienced Access developers use Macros

    Linq ;0)>
    The problem with making anything foolproof...is that fools are so darn ingenious!

    All posts/responses based on Access 2003/2007

  4. #4
    JoeM is offline VIP
    Windows XP Access 2007
    Join Date
    Jun 2012
    Posts
    3,904
    Excel is the product that has the built-in Macro Recorder.

    In Access, you can create/build Macros yourself, and then Convert them to Visual Basic. I find that tool comes in handy.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. enter ID automatically or manually
    By msasan1367 in forum Access
    Replies: 3
    Last Post: 06-03-2013, 10:21 AM
  2. Manually SAVE a record on a bound form
    By goodguy in forum Forms
    Replies: 2
    Last Post: 09-25-2011, 11:54 AM
  3. Manually Split a Database
    By ksmith in forum Programming
    Replies: 3
    Last Post: 12-01-2010, 03:15 PM
  4. Manually autonumber a field
    By apsf68 in forum Access
    Replies: 15
    Last Post: 11-13-2010, 04:04 PM
  5. Manually changing attribute
    By michaeljohnh in forum Programming
    Replies: 4
    Last Post: 09-14-2010, 12:50 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums