Is It Possible To Email A FORM In Snapshot Format?

Sep 5, 2006

Is it possible to email as attachment a FORM in snapshot format?
I have a form that gets the results of a query. I'd like to send the data displayed on this form as snapshot format. Possible? Any alternatives? Suggestions? Please help, i've looked high and low.

View Replies


ADVERTISEMENT

Email Snapshot Format...??? By Default

May 25, 2004

Using the access ‘Mail Report’ function, the ‘send’ dialog box comes up to select format… Is there a way to pre-select the snapshot format using code.?

View 5 Replies View Related

Email In Snapshot Format And Subject Line

Oct 28, 2004

Hi,

I have been reading all of your post for days now and can't find the answer to my question.

I have however found the answer to one of my programming problems. Thanks to all of you.

I have used Access as a data supplier but this is my first attempt to program in access.

I have absolutly no experience with VB code. And a limited amount of experience with macros in access only.

My question(s) are:

1. I need to send a single report (page) in an email (snapshot format) to a person using a command button. This report should be sent from the form that the person is currently looking at. Currently my command button sends the report in snapshot format but it sends the whole database.

2. This report will be used as a tracking mechanism for another department and I will need a specific name to store the email in a certain location. So that it can be tracked at a later date. I want (that doesn't mean that it can) Access to automatically put the subject line in the email. I know under the sendobject macro you can set the subject line the same for each email. But I need the subject line to match the information in several of my text boxes from a table. For instance: Subject line should read: [Permit number][CountyId][Inspector's Initials][Date]. Can this be done at all and if so how.

Thanks so much for all that you have done already.

Tasha

View 14 Replies View Related

Form>Snapshot>Email (AC97)

Jan 10, 2006

First off, hello to everyone here. I have been using these forums for a couple of months now and they have helped me solve many, many problems.

I've not needed to register before now because everything I needed to find out I was able to find an answer for, so THANK YOU:)

Anyways, back to business............................

I've built a reporting application where the users basically enter details on a form that performs a few lookups to autofill some info and they input the rest.

What happens next is when they submit the 'form', it appends details to a table and sends an email with the details entered to an address specified by a populated text box on the form

One of 3rd party contractors has requested we send this info in .snp format instead of just referencing the textboxes in the body of the mail.

I have created a duplicate of the form in snapshot but cannot figure out how to do the following:

1. Reference the open form to populate the fields

2. Then attach this to the email

Any help would be greatly appreciated.......as I'm tearing my hair out (and I don't really have much left to tear out anyway)

Many thx in adv

View 6 Replies View Related

PDF Format For Email Attachments Which Are In SNP Format

Mar 2, 2012

We're using Access 2010 on Windows 7.We have a large database design where we send reports as e-mail attachments. We need to change the way the file is automatically created when sent. I goes to snapshot form every time we attach it to an e-mail. How can we get rid of the snapshot .snp file format? How can we change it to pdf or accbd?

View 3 Replies View Related

Date Format When Passing Data To An Email

Aug 31, 2005

I have a button on a form that creates an email and inserts fields from my database. I have a field that is set to Long Date format type, but when it populates the email, it shows as a Short Date format type. Is there anyway to retain the Long Date format?

View 1 Replies View Related

Email Table In Text File Format

Apr 11, 2006

Hi,
I am trying to email a table in text format using :

DoCmd.SendObject acSendTable, "Table", acFormatTXT, , , , "Results", "Attached are the reslts"

It sends the file in text file format, but it adds "-" & "|" characters all over the file. Is there a way that I can send the file in simple "Comma Separated" file format.

Thx,

Jatz

View 1 Replies View Related

Email Table In Text File Format

Apr 11, 2006

Hi,
I am trying to email a table in text format using :

DoCmd.SendObject acSendTable, "Table", acFormatTXt, , , , "Results", "Attached are the reslts"

It sends the file in text file format, but it adds "-" & "|" characters all over the file. Is there a way that I can send the file in simple "Comma Separated" file format.

Thx,

Jatz

View 2 Replies View Related

Forms :: Email Current Record In PDF Format

May 23, 2013

I am new to Access. I am using Access 2010. I have searched and found several articles on emailing the current record shown on a form but haven't been able to get any of them to work.

My goal is to have a user input information onto the form and then have one button the user will click that will save the current record, email the current record in pdf, and then close the form.

The form name is: frmCorrectiveActions. The unique identifier for a record is: Corrective Action ID.

The last coding I tried is below. I know something is wrong but have copied this code from another post about emailing forms so I'm not even sure what half of it means.

I am getting the message Run-time error '3075': Syntax error (missing operator) in query expression "Corrective Actions ID = 23' and when I hit debug this is highlighted: qry.SQL = strSQL

form Private Sub Email_Click()
Dim qry As DAO.QueryDef
Dim strSQL As String
Dim ReportQueryName As String
ReportQueryName = "qryCorrectiveActions"
Set qry = CurrentDb.QueryDefs(ReportQueryName)

[Code] ....

View 5 Replies View Related

Modules & VBA :: HTML Format Email With Hyperlink

Aug 20, 2014

I am using the following vba code to create and send an html format email message. The key information in the email is a hyperlink to a network drive folder location using [Directory] as a hyperlink table value to get the address that is stored like this:
K:PipelinesP9 - TEP ProductsMOP AID-1500Final Approved

The email hyperlink that is produced looks like this:

#K:PipelinesP9_-_TEP_ProductsMOP_AID-
Dim appOutLook As Outlook.Application
Dim MailOutLook As Outlook.MailItem
Dim MOPVDB As String
MOPVDB = "H:PGADSBYMOP VALIDATIONTRACKINGMOPVDBMOP Validation DatabaseFE.accdb"
Set appOutLook = CreateObject("Outlook.Application")

[code]...

View 1 Replies View Related

How To Properly Get Email Body To Format Correctly

Jul 24, 2015

how to properly get my email body to format correctly? I am obviously misusing the .HTMLbody/tags incorrectly. The email generates with the attachments as expected, but the email body message is just runon.

Code:
Private Sub Command29_Click()
Dim appOutLook As Outlook.Application
Dim MailOutLook As Outlook.MailItem
Set appOutLook = CreateObject("Outlook.Application")

[code]....

View 6 Replies View Related

Modules & VBA :: Lotus Notes Email In Html Format

Jul 2, 2014

I'm trying to create a lotus notes email through vba that contains data from one of my access tables. Since I'd like the data to be displayed in a tabular fashion, I'm trying to format the body of the email in html.

View 1 Replies View Related

Exporting Table In Excel Format And Email As Well At Certain Time Of Day

Sep 6, 2012

I want to export a table in access table .

1. for example every day at 8.00 it create an output excel file.
2. Attach the file and send to a fixed email at that time.

View 1 Replies View Related

Send Report (PDF Format) Individually By Email Address

Sep 9, 2013

I need to send the report using DoCmd.SendObject. However, I need to send it based on each tech's job via email.

Currently all tech and jobs on the reports together. I need it to pull the email address and only send to that tech its jobs.

Currently I'm using the basic vba code

DoCmd.SendObject acSendReport, "R_DispatchInspectors", acFormatPDF, "email@me.com", , , "Job number", "Please see attached", False

However do I allows this to send individual report connected to email address. (Which will have each tech's specific jobs sent to them only).

table name: Inspectors (this one have their email address)
Table name: JObs
Report name: R_DispatchInspectors

View 3 Replies View Related

Modules & VBA :: Subform In Continuous Records Format - Send Contents Into The Body Of Email

Nov 10, 2014

I have a subform in Continuous Records format (records displayed are determined by controls on the parent). I would like to create a button that prepares an email and copies the contents of that subform in to the body of an email message.

The email. I have a method to create a new email, set To, CC, Subject and even Message Text.

Code:
strTo = txtName
strCC = txtManager
strSubject = "Something"
strMessage = "Hi, please find below list of details from X Y and Z" & vbnewline & vbnewline

That all works. Thats fine

The Records: I have found ways to have them added as an attachment, either the the SendObject and OutputTo method but I would like the list of records to be converted to a text string so I can include it within my strMessage variable, not include it as an attachment.

Code:
strMessage = strMessage & "Subform Records to go here"...

View 7 Replies View Related

Modules & VBA :: Form Which Has Button To Email Data Out In Standard Email Message

Jan 15, 2014

I have a form which has a button to email the data out in a standard email message.

Private Sub Command60_Click()
Dim MyDb As dao.Database
Dim rsEmail As dao.Recordset
Dim sToName As String
Dim sSubject As String
Dim sMessageBody As String

[code]...

This works well enough, however, FIELDS 11 through to 16 contain the venue address. This is all we ll and good if every field of the venue address is populated. here are times when not all of the fields are populated, for instance, the address might only be 5 lines.I know I can do this using IIf statements on a report, but how can i achieve the same thing for the email.

View 6 Replies View Related

Snapshot Defaults

Aug 6, 2007

I am having a problem with 3 pc's attached to our network but at a different campus. They have been complaining that the Snapshot Views of reports they are running are stopping the print queue by asking to load paper type 'bond' to the printer. I have checked the Snapshot Viewer printer settings on thoses machines and indeed they are defaulting to 'paper type - bond'. Setting the paper type to Plain or Unspecified will only print on that type for that instance. Is there anywhere to set the default paper type, i cannot find anything!!

View 5 Replies View Related

Snapshot Viewer Orientation

Aug 28, 2006

Wonder whether anyone can help me?

Each day I produce reports from access and email then out using the snapshot viewer format. The majority of recipients open this find and the report is absolutely fine, however, when other recipients open the report it comes out all slanted and blurred. It almost looks like there snapshot viewer is squashing a landscape report into a portrait view. Does anyone know how to correct this, as its driving me mad trying to find an answer?

thanks:)

View 1 Replies View Related

Emailing A SnapShot Report

Apr 4, 2006

I am using Access 2000, Windows XP and Groupwise 6.5. I am trying to email an employee leave report using the SendObject method. I would like to use the SnapShot format. Must I save the report before I send it? I tried acFormatSNP with no success. Thanks for all your help.

View 1 Replies View Related

Snapshot To Word Document

Jul 18, 2006

I have the following button on a form:



When I press it a mail is being send with a snapshot attached to it



Instead of a snapshot I want it to attach it as a word document.

Here you see the code that is used. I noticed it says snapshot format on a line but I don't know what the name is for a word document.

Code:Private Sub cmdMail_Click()On Error GoTo Err_cmdMail_Click Dim stDocName As String Dim V_EmailAdres As String If Not (IsNull(Me.HauliersEMAIL.Value)) And Me.HauliersEMAIL.Value <> "" Then V_EmailAdres = Me.HauliersEMAIL.Value Else V_EmailAdres = "" End If stDocName = "TransportOrder" DoCmd.SendObject acReport, stDocName, "Snapshot Format", V_EmailAdres, , , "Transport Order BP", ""Exit_cmdMail_Click: Exit SubErr_cmdMail_Click: MsgBox Err.Description Resume Exit_cmdMail_Click End Sub

Thanks in advance

View 2 Replies View Related

Save Snapshot As File

Mar 22, 2007

Hello,
I am using a useful function to save data of a form using the snapshot utility. I open the form, add or change data and sent the form to other users via e-mail. The snapshot uses a report. The code to do this is the following:

Me.Refresh
DoCmd.SendObject acReport, "EmailmyForm", "SnapshotFormat(*.snp)", "", "", "", "Action Required", "Please take action on the attached case.", False, ""

I was now thinking if it is possible to save the shapshot report as a file directly into a selected folder on my S drive (ex. S0000abmyfolder. I will need that the file is automatically named for my with the SSN present on the form.

Any idea or help? Thanks.

View 12 Replies View Related

Automatically Create Snapshot Reports

May 22, 2005

Is there a way via code in a module to automatically create a snapshot of a report, save it in a specifed folder location in the code and save it as the current date as the file name when a button is clicked.

I'm looking on how to do this as I have many reports to create, move to an intranet folder and then name it to the current date. It will save me lots of time if this can be done automatically.

I am using MS Access 2000 and the folder location will be on my hard drive.

Thanks
Aden

View 2 Replies View Related

Problem With Creating Snapshot Files

Jul 6, 2005

For some reason, I can no longer create snapshot files of my Access reports. I used to be able to do it on my computer.

I have downloaded the recent snapshot download from microsoft.com but have had no luck.

Can anyone help?

Thanks

View 5 Replies View Related

Snapshot Viewer Control Problem

Jul 24, 2006

I'm using the Snapshot Viewer control in one of my forms to display reports within the form. This works fine, except that with multiple page reports, there is no button to change pages, users have to right click and select 'next page.' In design mode the buttons to change pages and print appear at the bottom, but for some reason they don't show up when viewing the form in form view.

Has anyone run into this issue before?

Thanks

View 1 Replies View Related

Snapshot Viewer Problem - Very Strange

Sep 19, 2006

hi
i am using a macro with the outputTo method for a report. i have the report outputed as a snapshot file. it was working fine but now when it outputs the report the extension is missing; the file is created but with no extension. i tried changing the output format to excel but the extension was still missing. i also tried renaming my output report within the macro with the extension .snp and with .xls. snapshot viewer or excel would not open these programs.
anybody else come across this problem?
any ideas?

thanks

View 1 Replies View Related

Import Data In Database From Snapshot File?

Apr 30, 2005

I want to import data in access or excel from snapshot file- *.snp. Can I?
10x

View 6 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved