Code to export a table via E-Mail - Microsoft Access / VBA

Andy48

Hi everyone,

Can anyone point me in the direction of how to export a table, in
excell format automatically via E-Mail?

regards

Andy48

Nov 13 '05 #1

Subscribe Post Reply

1506

Allen Browne

Perhaps something like this:
DoCmd.SendObject acSendTable, "Table1", acFormatXLS, _
"so*****@somewhere.com" _
,,,"Here's ya table", "Attached find Table1", True

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Andy48" <An****@ajgreen1953.fsnet.co.uk> wrote in message
news:11**********************@g14g2000cwa.googlegr oups.com...

Hi everyone,

Can anyone point me in the direction of how to export a table, in
excell format automatically via E-Mail?

regards

Andy48

Nov 13 '05 #2

Alan Webb

Andy48,
Docmd.SendObject is one way.

"Andy48" <An****@ajgreen1953.fsnet.co.uk> wrote in message
news:11**********************@g14g2000cwa.googlegr oups.com...

Hi everyone,

Can anyone point me in the direction of how to export a table, in
excell format automatically via E-Mail?

regards

Andy48

Nov 13 '05 #3

Similar topics

How do you export?

by: Do Park via SQLMonster.com | last post by:

Hello all, I don?t often export data from a table. I am wondering how you export data from a table. I?d like to know how you export in real world. Do you export data from a table to a flat...

Microsoft SQL Server

Export DataView

by: nologin | last post by:

Is it possible to export data exposed by DataView to Excel file for example ? Seba

Visual Basic .NET

Change table date/time field to text field in code

by: Dixie | last post by:

How can I programatically, take some Date/Time fields present in a table in the current database and change their type to text? dixie

Microsoft Access / VBA

code to export to multiple Excel worksheets within single workbook

by: paul.chae | last post by:

I have a table in Access with about 3000 records. There are ~60 unique values in the ID field for the 3000 records. What I would like to do is automatically generate multiple Excel worksheets...

Microsoft Access / VBA

correct equivalent construct for 1 line of code

by: pamela fluente | last post by:

Hello, for the following code, VS suggests that construct (width= height= ) is out of date and a newer one is recommended: <table><tr><td width="92" height="38" valign="middle">AnyThing</td></...

HTML / CSS

EXPORT and Delete

by: jefftyzzer | last post by:

Friends: Let's say I'd like perform a delete, but before I delete, I'd like to export the target rows. I could use an export whose SELECT clause references the OLD TABLE of a DELETE, but the...

DB2 Database

Export Table Data To Formatted Text File

by: NEWSGROUPS | last post by:

I have data in a table in an Access 2000 database that needs to be exported to a formatted text file. For instance, the first field is an account number that is formatted in the table as text and...

Microsoft Access / VBA

Export fast, my code slow =[

by: eselk | last post by:

I'm doing some speed tests. I created a brand-new table, with just one "Long Integer" field. I'm testing adding 1000 records. If I use the "Export" feature in Access, it takes only a few seconds...

Microsoft Access / VBA

overflow during ODBC export

by: Edward Reid | last post by:

OK, I've been watching my DB grow and have known for a long time I would have to move the back end, but of course I waited until I started getting odd behavior (at about 1.92GB). So today I...

Microsoft Access / VBA

calling stored procedure from Perl code

by: rajpar | last post by:

Environment: Solaris (client + server) db2 version 7.2 latest fixpak (DB2 v7.1.0.111", "s050516" and "U803330") Compiler: gcc Here is my SP code executed on the client: CREATE PROCEDURE...

DB2 Database

Easy Steps to Fix "Canon Printer Won't Connect to WiFi Network"

by: taylorcarr | last post by:

A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...

General

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

Batch import of multiple excel files into the database

by: ryjfgjl | last post by:

If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...

Data Management

Merging data from multiple Excel files

by: ryjfgjl | last post by:

In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...

Data Management

Navigating the Data Structures and Algorithms (DSA)

by: BarryA | last post by:

What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...

Algorithms / Advanced Math

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

The easy way to turn off automatic updates for Windows 10/11

by: Hystou | last post by:

Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...

Windows Server