Email Invoice

Hi
I want to email Invoice ID1 from a list of Invoices in a datasheet

My code for printing is
strDocName = "rptInvoice"
strWhere = "[InvID]=" & Me.fsubPrintInvoice.Form![InvID]
DoCmd.OpenReport strDocName, acPreview, , strWhere

I am trying the following adjustment with the sendObject

'DoCmd.SendObject acSendReport, "rptInvoice" = "[InvID]=" &
Me.fsubPrintInvoice.Form![InvID], acFormatSNP, _
"", , , "Your Invoice....", "If you can not view the report
you will need to download the free SnapShot reader at
www.microsoft.com/downloads (Search by Keywords SnapShot)", True

And it is not working
Can anyone help or advise a better method

Regards
DD

Nov 13 '05 #1

Subscribe Post Reply

1875

Filips Benoit

"rptInvoice" = "[InvID]=" & Me.fsubPrintInvoice.Form![InvID],
See correction below
"rptInvoice", "InvID]=" & Me.fsubPrintInvoice.Form![InvID],

Filip

"DD" <da**********@bigpond.com.au> wrote in message
news:14**************************@posting.google.c om...

Hi
I want to email Invoice ID1 from a list of Invoices in a datasheet

My code for printing is
strDocName = "rptInvoice"
strWhere = "[InvID]=" & Me.fsubPrintInvoice.Form![InvID]
DoCmd.OpenReport strDocName, acPreview, , strWhere

I am trying the following adjustment with the sendObject

'DoCmd.SendObject acSendReport, "rptInvoice" = "[InvID]=" &
Me.fsubPrintInvoice.Form![InvID], acFormatSNP, _
"", , , "Your Invoice....", "If you can not view the report
you will need to download the free SnapShot reader at
www.microsoft.com/downloads (Search by Keywords SnapShot)", True

And it is not working
Can anyone help or advise a better method

Regards
DD

Nov 13 '05 #2

by: Ian N | last post by:

Hi, I'm creating a site that posts orders to an email address when they're submitted, these orders need to be in the form of official invoices so i'm using HTML to format them. I already have...

PHP

ACG Soft - "PDF & Mail Class Library" - Email PDF from Access 2k3

by: JvdWal | last post by:

Hi, I've been trying the PDF & Mail Class Library from ACG Soft in combination with Northwind-2k3 style of db. Can someone help me with the error which is popping up: (which I cant get solved..)...

Microsoft Access / VBA

Invoice numbering

by: David B | last post by:

I am creating invoices for an app I am busy with. The transactions for the invoice come from 2 tables which store Sales and Facilities Hire. The current arrangement is that I create a temp...

Microsoft Access / VBA

Help:creating a new invoice?

by: NomoreSpam4Me | last post by:

Hi there i have a little problem with my invoice. Here it is: i have a main menu with buttons, one of my button is "Create new invoice", when click on it a form pop up so i can enter my...

Microsoft Access / VBA

Every customer's last invoice

by: Herman Beeksma | last post by:

Hi there! I have two tables: Customer (ID, Name) Invoice (ID, Date, Customer, Amount) and want to select only the *last* invoice for each customer. It's easy to get each customer's last...

Microsoft Access / VBA

Trying to create an invoice from access and use oulook to email

by: rrhistory | last post by:

I have an access database with information such as name, address, item buying, cost, qty etc. This was in excel originally, but I thought Access would be the better way to create the forms I need. ...

Microsoft Access / VBA

Save PDF and Email code error

by: xian2 | last post by:

Hi All, I have been using this guide http://www.compasscomputing.co.uk/code/AcceesReportsToPDFandEmail.htm to create a command button that automatically saves and e-mails your report and have...

Microsoft Access / VBA

Sending formated Email with database mail sql 2005

by: TGS | last post by:

Hi, My objective is to send out invoice statements with database mail by means of a stored procedure. There are two tables, Table1 is customer information, Table2 is invoice information. Table 1...

Microsoft SQL Server

DoCmd.OpenReport "Invoice", acPreview

by: gazza10001 | last post by:

Hi i hope you can help my company uses access and has modified for its needs usually what happens is you serach for the invoice by its number and then it brings all the information up such as...

Microsoft Access / VBA

How to turn on java script in a villaon keypad mobile phone

by: Charles Arthur | last post by:

How do i turn on java script on a villaon, callus and itel keypad mobile phone

Java

Basic Javascript concepts

by: aa123db | last post by:

Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...

Javascript

Migrating Website to Cloud - Emmanuel Katto

by: emmanuelkatto | last post by:

Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel

General

Looking to do Android software development, any suggestions? Is flutter better?

by: nemocccc | last post by:

hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?

General

Is that possible of reading the .csv file in column wise and the column have different lengths ?

by: Sonnysonu | last post by:

This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

C / C++

How to build RAID in BIOS?

by: Hystou | last post by:

There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

Computer Hardware

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...

General

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...

Windows Server

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...

C / C++

Similar topics