Welcome to SPN

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

Sign Up Now!

How to email an existing xls file from “My Documentsâ€

Discussion in 'Information Technology' started by Adnan, Jul 28, 2006.

  1. Adnan

    Adnan
    Expand Collapse
    Guest

    Hi All,
    I have searched and thought I found what I was looking for not really – I
    want a command button created on a form that will email me an existing xls
    file from “My Documents†something that would have the file attached and a
    curtain text with subject and email address already on place (command button
    that would bring the message on display mode autosend)

    ------------------------------------------------------------------------------------------------
    To: someone@domain.com
    Cc: me@domain.com
    Subject: Service Order
    Attach: ServiceOrder.xls (attached file goes here)

    Body:

    Dear Customer,
    Please fill out the attached above and send it to address on CC filed….
    Balah balha… etc…



    Thank you!
    Me
    ------------------------------------------------------------------------------------------------

    This would be an awesome help!
    I thank you all****

    --
    Please post all your inquiries on this community so we can all benefit -
    Thank you!
     
  2. Loading...


  3. Joseph Meehan

    Joseph Meehan
    Expand Collapse
    Guest

    Re: How to email an existing xls file from "My Documents"

    Adnan wrote:
    > Hi All,
    > I have searched and thought I found what I was looking for not really
    > - I want a command button created on a form that will email me an
    > existing xls file from "My Documents" something that would have the
    > file attached and a curtain text with subject and email address
    > already on place (command button that would bring the message on
    > display mode autosend)
    >


    Sorry. This is a newsgroup dedicated to questions about Access, the
    database program in Office Professional. It appears your question may not
    be related to these subjects. The Microsoft help system is not all that
    clear and may have misdirected you here.

    It is best to ask your questions in a newsgroup dedicated to the
    subject of your question. You should find people better able to address
    your problem there.
    http://tc2.atspace.com/0013-HowToSearch.htm#FindNewsgroup may help.


    Note: It is always best to indicate the name and version of any
    program(s) you may be using when asking a question and also indicate the
    operating system (like Windows XP or 98) when you ask a question.


    --
    Joseph Meehan

    Dia duit
     
  4. Adnan

    Adnan
    Expand Collapse
    Guest

    Re: How to email an existing xls file from "My Documents"

    Joseph,
    I appreciate you answer but I am sure this is the right place to post such a
    question/inquiry. But I guess, I must have not been clear on what I was
    looking for. What I needed and still need is to be able to email a attachment
    from a Microsoft Office Access Form, I have found lots of related topics but
    not this particular one. I have created a ms access database for customers,
    and I want them to fill a few fields on the form then if there’s anything
    else they can just click on a button which would open up outlook window with
    an attachment uploaded and a text message on email body that would say
    “Please fill out the attached above on this message†then he/she fills the
    attached (and clicks send button of the outlook mail window).

    Thank you,
    Adnan :)

    --
    Please post all your inquiries on this community so we can all benefit -
    Thank you!


    "Joseph Meehan" wrote:

    > Adnan wrote:
    > > Hi All,
    > > I have searched and thought I found what I was looking for not really
    > > - I want a command button created on a form that will email me an
    > > existing xls file from "My Documents" something that would have the
    > > file attached and a curtain text with subject and email address
    > > already on place (command button that would bring the message on
    > > display mode autosend)
    > >

    >
    > Sorry. This is a newsgroup dedicated to questions about Access, the
    > database program in Office Professional. It appears your question may not
    > be related to these subjects. The Microsoft help system is not all that
    > clear and may have misdirected you here.
    >
    > It is best to ask your questions in a newsgroup dedicated to the
    > subject of your question. You should find people better able to address
    > your problem there.
    > http://tc2.atspace.com/0013-HowToSearch.htm#FindNewsgroup may help.
    >
    >
    > Note: It is always best to indicate the name and version of any
    > program(s) you may be using when asking a question and also indicate the
    > operating system (like Windows XP or 98) when you ask a question.
    >
    >
    > --
    > Joseph Meehan
    >
    > Dia duit
    >
    >
    >
     
  5. Pieter Wijnen

    Pieter Wijnen
    Expand Collapse
    Guest

    Re: How to email an existing xls file from "My Documents"

    DoCmd.SendObject

    HTH

    Pieter

    "Adnan" <Adnan@discussions.microsoft.com> wrote in message
    news:809C09A0-94EF-44E1-960C-6434CEF3EBB6@microsoft.com...
    > Joseph,
    > I appreciate you answer but I am sure this is the right place to post such
    > a
    > question/inquiry. But I guess, I must have not been clear on what I was
    > looking for. What I needed and still need is to be able to email a
    > attachment
    > from a Microsoft Office Access Form, I have found lots of related topics
    > but
    > not this particular one. I have created a ms access database for
    > customers,
    > and I want them to fill a few fields on the form then if there's anything
    > else they can just click on a button which would open up outlook window
    > with
    > an attachment uploaded and a text message on email body that would say
    > "Please fill out the attached above on this message" then he/she fills the
    > attached (and clicks send button of the outlook mail window).
    >
    > Thank you,
    > Adnan :)
    >
    > --
    > Please post all your inquiries on this community so we can all benefit -
    > Thank you!
    >
    >
    > "Joseph Meehan" wrote:
    >
    >> Adnan wrote:
    >> > Hi All,
    >> > I have searched and thought I found what I was looking for not really
    >> > - I want a command button created on a form that will email me an
    >> > existing xls file from "My Documents" something that would have the
    >> > file attached and a curtain text with subject and email address
    >> > already on place (command button that would bring the message on
    >> > display mode autosend)
    >> >

    >>
    >> Sorry. This is a newsgroup dedicated to questions about Access, the
    >> database program in Office Professional. It appears your question may
    >> not
    >> be related to these subjects. The Microsoft help system is not all that
    >> clear and may have misdirected you here.
    >>
    >> It is best to ask your questions in a newsgroup dedicated to the
    >> subject of your question. You should find people better able to address
    >> your problem there.
    >> http://tc2.atspace.com/0013-HowToSearch.htm#FindNewsgroup may help.
    >>
    >>
    >> Note: It is always best to indicate the name and version of any
    >> program(s) you may be using when asking a question and also indicate the
    >> operating system (like Windows XP or 98) when you ask a question.
    >>
    >>
    >> --
    >> Joseph Meehan
    >>
    >> Dia duit
    >>
    >>
    >>
     
  6. Joseph Meehan

    Joseph Meehan
    Expand Collapse
    Guest

    Re: How to email an existing xls file from "My Documents"

    Adnan wrote:
    > Joseph,
    > I appreciate you answer but I am sure this is the right place to post
    > such a question/inquiry. But I guess, I must have not been clear on
    > what I was looking for.


    Normally that would not have been necessary, but since Access is the
    first item on the list of MS newsgroups we get a lot of people here looking
    for something else. Your message was not clear it was for mailing from
    access, so I thought it would be warn you early with my standard message.

    Take a look at the SendObject command, that should take care of it.

    > What I needed and still need is to be able to
    > email a attachment from a Microsoft Office Access Form, I have found
    > lots of related topics but not this particular one. I have created a
    > ms access database for customers, and I want them to fill a few
    > fields on the form then if there's anything else they can just click
    > on a button which would open up outlook window with an attachment
    > uploaded and a text message on email body that would say "Please fill
    > out the attached above on this message" then he/she fills the
    > attached (and clicks send button of the outlook mail window).
    >
    > Thank you,
    > Adnan :)
    >
    >
    >> Adnan wrote:
    >>> Hi All,
    >>> I have searched and thought I found what I was looking for not
    >>> really - I want a command button created on a form that will email
    >>> me an existing xls file from "My Documents" something that would
    >>> have the file attached and a curtain text with subject and email
    >>> address already on place (command button that would bring the
    >>> message on display mode autosend)
    >>>

    >>
    >> Sorry. This is a newsgroup dedicated to questions about Access,
    >> the database program in Office Professional. It appears your
    >> question may not be related to these subjects. The Microsoft help
    >> system is not all that clear and may have misdirected you here.
    >>
    >> It is best to ask your questions in a newsgroup dedicated to the
    >> subject of your question. You should find people better able to
    >> address your problem there.
    >> http://tc2.atspace.com/0013-HowToSearch.htm#FindNewsgroup may help.
    >>
    >>
    >> Note: It is always best to indicate the name and version of any
    >> program(s) you may be using when asking a question and also indicate
    >> the operating system (like Windows XP or 98) when you ask a question.
    >>
    >>
    >> --
    >> Joseph Meehan
    >>
    >> Dia duit


    --
    Joseph Meehan

    Dia duit
     
  7. Ron2006

    Ron2006
    Expand Collapse
    Guest

    Re: How to email an existing xls file from "My Documents"

    If you are using Outlook and
    if the attachment is something other that what send object allows you
    to send

    you may want to look at automation. Here is an example of sending
    email via outlook

    ====================================
    Set o = CreateObject("Outlook.Application")

    Set m = o.CreateItem(0)

    m.To = "Paul Tucker" ' The distribution list name or email
    address(s) goes here

    ' m.CC = ' email address for copy

    ' m.BCC = 'email address for Blind Copy

    m.Subject = "SUPP Analysis Spreadsheet "

    m.body = Chr(13) & Chr(13) & _
    " Date: " & date & Chr(13) & _
    Chr(13)

    m.attachments.Add exportName ' point to the full address of
    attachment here
    ' There can be multiple of the above

    ' m.display ' display shows email and the user has to press send button

    m.send ' Send does it automatically with security from Outlook

    Ron
     
  8. Adnan

    Adnan
    Expand Collapse
    Guest

    Re: How to email an existing xls file from "My Documents"

    Ron,
    Your reply is exactly what I was looking for, you read my mind and you are
    definitely a LIFE SAVER – thank you for everything, and I thank the other,
    too. God bless you all!
    Adnan, Computer Science Student, Kosovo

    --
    Please post all your inquiries on this community so we can all benefit -
    Thank you!


    "Ron2006" wrote:

    > If you are using Outlook and
    > if the attachment is something other that what send object allows you
    > to send
    >
    > you may want to look at automation. Here is an example of sending
    > email via outlook
    >
    > ====================================
    > Set o = CreateObject("Outlook.Application")
    >
    > Set m = o.CreateItem(0)
    >
    > m.To = "Paul Tucker" ' The distribution list name or email
    > address(s) goes here
    >
    > ' m.CC = ' email address for copy
    >
    > ' m.BCC = 'email address for Blind Copy
    >
    > m.Subject = "SUPP Analysis Spreadsheet "
    >
    > m.body = Chr(13) & Chr(13) & _
    > " Date: " & date & Chr(13) & _
    > Chr(13)
    >
    > m.attachments.Add exportName ' point to the full address of
    > attachment here
    > ' There can be multiple of the above
    >
    > ' m.display ' display shows email and the user has to press send button
    >
    > m.send ' Send does it automatically with security from Outlook
    >
    > Ron
    >
    >
     

Share This Page