Results 1 to 5 of 5
  1. #1
    jimaccessnovice is offline Novice
    Windows 7 64bit Access 2016
    Join Date
    Feb 2018
    Posts
    10

    EmailDatabaseObject Help

    Hi, I can't understand why the EmailDatabaseObject macro below works for me but not for other users. The macro successfully opens Outlook, addresses it correctly and applies the subject correctly. It does not try to create and attach an object (which is my intent). However, when the same macro is run by another user, it wants to attach an object and will not go to Outlook without an object being created. Below is the macro...and help would be appreciated.

    Thank you,

    Click image for larger version. 

Name:	Capture.JPG 
Views:	19 
Size:	47.4 KB 
ID:	32775

  2. #2
    ranman256's Avatar
    ranman256 is online now VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    the macros need enabled for each user.
    File, options, trust center, trust center settings, macro settings, ENABLE ALL MACROS
    and
    everyone would have to have the exact same version of Outlook. If not, it could be missing in the reference:

    if you look in vbe, (alt-f11), tools, references,
    make sure there is no MISSING items checked.
    and that OUTLOOK x.x object library is checked

  3. #3
    jimaccessnovice is offline Novice
    Windows 7 64bit Access 2016
    Join Date
    Feb 2018
    Posts
    10
    Thank you...unfortunately it didn't work. However, I think I found the problem.
    I installed a 32 bit version of Office 365 on my machine (default value from Office 2013)...but then instructed to have my design team install 64 bit upgrade...unaware of the issues the 64 bit version is having.

    Now it seems that only 32 bit office installs work correctly. I even had a 64 bit machine save the file and the EmailObjectDatabase macro still looks for an object so that didn't work.

    So now I have to decide whether to have my team go back to a 32 bit install or try to create VBA code that will work in both 32 bit and 64 bit versions??? if that's even possible.

    If anyone can give me a simple VBA solution for the macro types attached it would be appreciated.



    Click image for larger version. 

Name:	wor.JPG 
Views:	16 
Size:	47.7 KB 
ID:	32790
    Click image for larger version. 

Name:	rfi.JPG 
Views:	16 
Size:	46.5 KB 
ID:	32791
    Click image for larger version. 

Name:	assoc.JPG 
Views:	15 
Size:	49.6 KB 
ID:	32792

  4. #4
    aytee111 is offline Competent At Times
    Windows 10 Access 2013 64bit
    Join Date
    Nov 2011
    Location
    Nomad
    Posts
    3,936
    You can convert these to VBA:

    In the top left of the window it says "Convert Macro to Visual Basic".

    Sometimes this seems to be grayed out. Here is the solution:
    "The solution I found was, rather than loading the form in Design View,
    I clicked the Macro button under Create on the Ribbon which brought up
    the Macro Design window. Under the Action Catalog window, there is a
    section called "In this Database." I clicked down to the form and
    textbox which contained the macro I wanted to convert, then double-
    clicked. The macro displayed in the left hand window and the "Convert
    Macro's to Visual Basic", was not grayed out so I clicked it and the
    conversion was simple after that."

    You will see that the VBA code follows the macro and you can easily see what is going on, it will all feel very similar to you.

  5. #5
    June7's Avatar
    June7 is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,816
    If you were declaring API function I would suggest you research PtrSafe but since you are not, I am at a loss as to why the code behaves differently. Frankly, suggest you install 32-bit Access. https://support.office.com/en-us/art...4-B56111A6F32D
    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.

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

Similar Threads

  1. Replies: 4
    Last Post: 04-22-2017, 08:05 AM
  2. EMailDatabaseObject Hangs
    By bragaglia in forum Macros
    Replies: 2
    Last Post: 02-03-2017, 02:44 PM
  3. EmailDatabaseObject Automate TO Field
    By Tlo in forum Macros
    Replies: 3
    Last Post: 06-24-2016, 11:05 AM
  4. emaildatabaseobject with date?
    By vicsaccess in forum Import/Export Data
    Replies: 5
    Last Post: 10-19-2015, 05:55 PM
  5. EmailDatabaseObject in Macro
    By Kmoney in forum Programming
    Replies: 5
    Last Post: 01-13-2012, 03:14 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