Enviar Informe por correo electrónico desde REGISTRO ACTUAL de Formulario

Article View: es.comp.bd.ms-access

Article #25

Back to es.comp.bd.ms-access Previous Next

#25

From: kommando
Date: Tue, 13 Jan 2009 17:20

29 lines
1914 bytes

Buenas a todos,

En un formulario tengo un boton de comando para enviar un informe por
correo electrónico. Este es el código:

Private Sub Enviar_Click()

On Error GoTo Err_Enviar_Click

    Dim stDocName As String
    stDocName = "Informe"
    DoCmd.SendObject acReport, "Informe", acFormatRTF,
Me.ComercialAsignado

Exit_Enviar_Click:

    Exit Sub

Err_Enviar_Click:

    MsgBox Err.Description
    Resume Exit_Enviar_Click

End Sub

Quisiera saber cómo puedo hacer para agregar un criterio que me
permita enviar el informe del registro actual del formulario.

Muchísimas gracias.

Technical Details

Message-ID: <0495bed4-e9ab-4d04-8f8c-b537eec3eb10@y1g2000pra.googlegroups.com>

Path: arc1-ca.pugleaf.net!g2news1.google.com!postnews.google.com!y1g2000pra.googlegroups.com!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Thread: 111a5a,8986e3268b8e9c0f,start
X-Google-Attributes: gid111a5a,domainid0,public,usenet
X-Google-Language: SPANISH,ASCII
Path: arc1-ca.pugleaf.net!g2news1.google.com!postnews.google.com!y1g2000pra.googlegroups.com!not-for-mail
From: kommando <raul.bh@terra.es>
Newsgroups: es.comp.bd.ms-access
Subject: Enviar Informe por correo electrónico desde REGISTRO ACTUAL de Formulario
Date: Tue, 13 Jan 2009 09:20:33 -0800 (PST)
Organization: http://groups.google.com
Lines: 29
Message-ID: <0495bed4-e9ab-4d04-8f8c-b537eec3eb10@y1g2000pra.googlegroups.com>
NNTP-Posting-Host: 80.37.192.158
Mime-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
X-Trace: posting.google.com 1231867233 31898 127.0.0.1 (13 Jan 2009 17:20:33 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Tue, 13 Jan 2009 17:20:33 +0000 (UTC)
Complaints-To: groups-abuse@google.com
Injection-Info: y1g2000pra.googlegroups.com; posting-host=80.37.192.158; 
 posting-account=b3TLqgoAAABTiE4BkuI7j43-e_mCswnt
User-Agent: G2/1.0
X-HTTP-UserAgent: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.2; SV1; .NET 
 CLR 1.1.4322; .NET CLR 2.0.50727; .NET CLR 3.0.04506.648; .NET CLR
 3.5.21022),gzip(gfe),gzip(gfe)