Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Blank Email Text with SendObject

Discussion in 'Information Technology' started by DEI, Nov 5, 2005.

  1. DEI

    DEI
    Expand Collapse
    Guest

    I am using the SendObject method to populate an email message with data from
    a form, etc. The code is below. It works fine for me. But I have put the
    database in a folder on a network shared drive and when another user on
    another computer clicks the button to generate the email message, the Address
    and Subject fields of the email message populate fine, but the message text
    comes out completely blank. No error message comes up, the email body is
    just blank.

    Do I need to configure Access a special way on this other computer? Is is a
    security/unsafe expressions issue? Do I need to configure Outlook in special
    way on the other computer?

    This is very frustrating as, again, it works fine on my machine. I have
    encountered these types of issues before when putting a database in a shared
    folder. Does anyone have any general advice about making a database function
    well in a shared environment?

    Thanks in advance.

    DEI

    Code Sample:

    em = Forms!frmREQUESTS.EMAIL

    DoCmd.SendObject , , , em, , , "Catering Request Confirmation #" &
    Forms!frmREQUESTS.REQCON, _
    "Nutrition Services has received your recent catering order for:" & vbCr &
    vbCr & _
    "Date: " & Forms!frmREQUESTS.EVENTDATE & vbCr & _
    "Time: " & Forms!frmREQUESTS.BEGX & vbCr & _
    "Location: " & Forms!frmREQUESTS.BLDGRM & vbCr & _
    "Number Attending: " & Forms!frmREQUESTS.NUMGUESTS & vbCr & _
    "Confirmation Number: " & Forms!frmREQUESTS.REQCON & vbCr & _
    "Requested by: " & Forms!frmREQUESTS.LNAME & ", " & Forms frmREQUESTS.FNAME
     
  2. Loading...

    Similar Threads Forum Date
    USA Utah Sikhs bring warmth to homeless with blanket donation Breaking News Dec 21, 2013
    History The Art of Firing Blanks: Jaswant Singh and the BJP Punjab, Punjabi, Punjabiyat Aug 25, 2009
    Sikh News Security blanket over Punjab as dera deadline draws close (IANS via Yahoo! India News Breaking News May 27, 2007
    Controversial Man stands by email: "Lose the traditions, or stay in India" Hard Talk Aug 11, 2012
    Disgusting email about asthma, MS, ADD and autism Parenting Aug 10, 2011

  3. Arvin Meyer [MVP]

    Arvin Meyer [MVP]
    Expand Collapse
    Guest

    Never run a database front-end from a network drive. Always split the
    database, link the database, and give each user their own copy which is to
    be run from their own workstation.
    --
    Arvin Meyer, MCP, MVP
    Microsoft Access
    Free Access downloads
    http://www.datastrat.com
    http://www.mvps.org/access

    "DEI" <DEI@discussions.microsoft.com> wrote in message
    news:7DBB8F74-4A62-4602-A817-2F56C9C3961D@microsoft.com...
    > I am using the SendObject method to populate an email message with data

    from
    > a form, etc. The code is below. It works fine for me. But I have put

    the
    > database in a folder on a network shared drive and when another user on
    > another computer clicks the button to generate the email message, the

    Address
    > and Subject fields of the email message populate fine, but the message

    text
    > comes out completely blank. No error message comes up, the email body is
    > just blank.
    >
    > Do I need to configure Access a special way on this other computer? Is is

    a
    > security/unsafe expressions issue? Do I need to configure Outlook in

    special
    > way on the other computer?
    >
    > This is very frustrating as, again, it works fine on my machine. I have
    > encountered these types of issues before when putting a database in a

    shared
    > folder. Does anyone have any general advice about making a database

    function
    > well in a shared environment?
    >
    > Thanks in advance.
    >
    > DEI
    >
    > Code Sample:
    >
    > em = Forms!frmREQUESTS.EMAIL
    >
    > DoCmd.SendObject , , , em, , , "Catering Request Confirmation #" &
    > Forms!frmREQUESTS.REQCON, _
    > "Nutrition Services has received your recent catering order for:" & vbCr &
    > vbCr & _
    > "Date: " & Forms!frmREQUESTS.EVENTDATE & vbCr & _
    > "Time: " & Forms!frmREQUESTS.BEGX & vbCr & _
    > "Location: " & Forms!frmREQUESTS.BLDGRM & vbCr & _
    > "Number Attending: " & Forms!frmREQUESTS.NUMGUESTS & vbCr & _
    > "Confirmation Number: " & Forms!frmREQUESTS.REQCON & vbCr & _
    > "Requested by: " & Forms!frmREQUESTS.LNAME & ", " & Forms

    frmREQUESTS.FNAME
     
  4. DEI

    DEI
    Expand Collapse
    Guest

    Will that solve the problem with the SendObject method? I understand about
    splitting the database, but the sendobject method is going to be in a public
    procedure in a code module that will reside on the users work station, is it
    not?

    What you are desribing is putting the forms, querys, reports, etc. on the
    persons workstation but leaving the underlying tables on the network drive,
    right?

    Will that effect the send object?

    Thanks.

    DEI

    "Arvin Meyer [MVP]" wrote:

    > Never run a database front-end from a network drive. Always split the
    > database, link the database, and give each user their own copy which is to
    > be run from their own workstation.
    > --
    > Arvin Meyer, MCP, MVP
    > Microsoft Access
    > Free Access downloads
    > http://www.datastrat.com
    > http://www.mvps.org/access
    >
    > "DEI" <DEI@discussions.microsoft.com> wrote in message
    > news:7DBB8F74-4A62-4602-A817-2F56C9C3961D@microsoft.com...
    > > I am using the SendObject method to populate an email message with data

    > from
    > > a form, etc. The code is below. It works fine for me. But I have put

    > the
    > > database in a folder on a network shared drive and when another user on
    > > another computer clicks the button to generate the email message, the

    > Address
    > > and Subject fields of the email message populate fine, but the message

    > text
    > > comes out completely blank. No error message comes up, the email body is
    > > just blank.
    > >
    > > Do I need to configure Access a special way on this other computer? Is is

    > a
    > > security/unsafe expressions issue? Do I need to configure Outlook in

    > special
    > > way on the other computer?
    > >
    > > This is very frustrating as, again, it works fine on my machine. I have
    > > encountered these types of issues before when putting a database in a

    > shared
    > > folder. Does anyone have any general advice about making a database

    > function
    > > well in a shared environment?
    > >
    > > Thanks in advance.
    > >
    > > DEI
    > >
    > > Code Sample:
    > >
    > > em = Forms!frmREQUESTS.EMAIL
    > >
    > > DoCmd.SendObject , , , em, , , "Catering Request Confirmation #" &
    > > Forms!frmREQUESTS.REQCON, _
    > > "Nutrition Services has received your recent catering order for:" & vbCr &
    > > vbCr & _
    > > "Date: " & Forms!frmREQUESTS.EVENTDATE & vbCr & _
    > > "Time: " & Forms!frmREQUESTS.BEGX & vbCr & _
    > > "Location: " & Forms!frmREQUESTS.BLDGRM & vbCr & _
    > > "Number Attending: " & Forms!frmREQUESTS.NUMGUESTS & vbCr & _
    > > "Confirmation Number: " & Forms!frmREQUESTS.REQCON & vbCr & _
    > > "Requested by: " & Forms!frmREQUESTS.LNAME & ", " & Forms

    > frmREQUESTS.FNAME
    >
    >
    >
     
  5. Arvin Meyer [MVP]

    Arvin Meyer [MVP]
    Expand Collapse
    Guest

    Answers in line:

    "DEI" <DEI@discussions.microsoft.com> wrote in message
    news:65E76103-F47D-489A-87D8-50188659C7B6@microsoft.com...
    > Will that solve the problem with the SendObject method? I understand

    about
    > splitting the database, but the sendobject method is going to be in a

    public
    > procedure in a code module that will reside on the users work station, is

    it
    > not?
    >
    > What you are desribing is putting the forms, querys, reports, etc. on the
    > persons workstation but leaving the underlying tables on the network

    drive,
    > right?


    Correct

    > Will that effect the send object?


    It may. The mail program may not have a client on the server, so it doesn't
    know what to do with SendObject. Also while the database file may be running
    from the server, the application is running on your desktop, so it's making
    an extra round trip and possibly conflicting with another user. Those
    conflicts often cause corruption.

    There is a bug in SendObject in Access 2000 versions:

    http://support.microsoft.com/default.aspx?scid=kb;en-us;260819

    That may be affecting you as well.
    --
    Arvin Meyer, MCP, MVP
    Microsoft Access
    Free Access downloads
    http://www.datastrat.com
    http://www.mvps.org/access

    > "Arvin Meyer [MVP]" wrote:
    >
    > > Never run a database front-end from a network drive. Always split the
    > > database, link the database, and give each user their own copy which is

    to
    > > be run from their own workstation.
    > > --
    > > Arvin Meyer, MCP, MVP
    > > Microsoft Access
    > > Free Access downloads
    > > http://www.datastrat.com
    > > http://www.mvps.org/access
    > >
    > > "DEI" <DEI@discussions.microsoft.com> wrote in message
    > > news:7DBB8F74-4A62-4602-A817-2F56C9C3961D@microsoft.com...
    > > > I am using the SendObject method to populate an email message with

    data
    > > from
    > > > a form, etc. The code is below. It works fine for me. But I have

    put
    > > the
    > > > database in a folder on a network shared drive and when another user

    on
    > > > another computer clicks the button to generate the email message, the

    > > Address
    > > > and Subject fields of the email message populate fine, but the message

    > > text
    > > > comes out completely blank. No error message comes up, the email body

    is
    > > > just blank.
    > > >
    > > > Do I need to configure Access a special way on this other computer?

    Is is
    > > a
    > > > security/unsafe expressions issue? Do I need to configure Outlook in

    > > special
    > > > way on the other computer?
    > > >
    > > > This is very frustrating as, again, it works fine on my machine. I

    have
    > > > encountered these types of issues before when putting a database in a

    > > shared
    > > > folder. Does anyone have any general advice about making a database

    > > function
    > > > well in a shared environment?
    > > >
    > > > Thanks in advance.
    > > >
    > > > DEI
    > > >
    > > > Code Sample:
    > > >
    > > > em = Forms!frmREQUESTS.EMAIL
    > > >
    > > > DoCmd.SendObject , , , em, , , "Catering Request Confirmation #" &
    > > > Forms!frmREQUESTS.REQCON, _
    > > > "Nutrition Services has received your recent catering order for:" &

    vbCr &
    > > > vbCr & _
    > > > "Date: " & Forms!frmREQUESTS.EVENTDATE & vbCr & _
    > > > "Time: " & Forms!frmREQUESTS.BEGX & vbCr & _
    > > > "Location: " & Forms!frmREQUESTS.BLDGRM & vbCr & _
    > > > "Number Attending: " & Forms!frmREQUESTS.NUMGUESTS & vbCr & _
    > > > "Confirmation Number: " & Forms!frmREQUESTS.REQCON & vbCr & _
    > > > "Requested by: " & Forms!frmREQUESTS.LNAME & ", " & Forms

    > > frmREQUESTS.FNAME
    > >
    > >
    > >
     
  6. DEI

    DEI
    Expand Collapse
    Guest

    Thanks for the help, and I did in fact create a database front end, put the
    tables in a shared network drive, etc., but the email message is still not
    working properly.

    Is there a security setting I need to change? Is there something in Outlook
    that I need to change to allow the message text to be sent to the email
    message? Do I need to digitally sign the code somehow?

    Is it possible that access regards the SendOject method as an unsafe
    expression and blocks its functionality? If so, is there a way to reset
    Access's security, beyond the macro security setting?

    Thanks.

    "DEI" wrote:

    > I am using the SendObject method to populate an email message with data from
    > a form, etc. The code is below. It works fine for me. But I have put the
    > database in a folder on a network shared drive and when another user on
    > another computer clicks the button to generate the email message, the Address
    > and Subject fields of the email message populate fine, but the message text
    > comes out completely blank. No error message comes up, the email body is
    > just blank.
    >
    > Do I need to configure Access a special way on this other computer? Is is a
    > security/unsafe expressions issue? Do I need to configure Outlook in special
    > way on the other computer?
    >
    > This is very frustrating as, again, it works fine on my machine. I have
    > encountered these types of issues before when putting a database in a shared
    > folder. Does anyone have any general advice about making a database function
    > well in a shared environment?
    >
    > Thanks in advance.
    >
    > DEI
    >
    > Code Sample:
    >
    > em = Forms!frmREQUESTS.EMAIL
    >
    > DoCmd.SendObject , , , em, , , "Catering Request Confirmation #" &
    > Forms!frmREQUESTS.REQCON, _
    > "Nutrition Services has received your recent catering order for:" & vbCr &
    > vbCr & _
    > "Date: " & Forms!frmREQUESTS.EVENTDATE & vbCr & _
    > "Time: " & Forms!frmREQUESTS.BEGX & vbCr & _
    > "Location: " & Forms!frmREQUESTS.BLDGRM & vbCr & _
    > "Number Attending: " & Forms!frmREQUESTS.NUMGUESTS & vbCr & _
    > "Confirmation Number: " & Forms!frmREQUESTS.REQCON & vbCr & _
    > "Requested by: " & Forms!frmREQUESTS.LNAME & ", " & Forms frmREQUESTS.FNAME
     

Share This Page