access class microsoft training - Ms Access to Outlook

The UK's most regular instructor-led training courses.
Training information: access class microsoft training · Microsoft.access.courses · Microsoft Access Training uk
See also · microsoft access training · access vba courses · access database course

Resolved · Low Priority · Version Standard

Ms Access to Outlook

Reza has attended:
Excel Advanced course

by - delegate Reza [10 posts] (2007 Jul 17 Tue, 14:32) Reply

MsAccess has two-toolbar button for emailing reports/tables and other stuff via Outlook.

Button 1) Mail as attachment
Button 2) Mail Recipient *

Unfortunately, Button 2 * is not highlighted in almost all possible default toolbars, customs. How can we make it highlighted so we can send email file directly NOT as a attachments. Or any other solutions exist to resolve the issue?

Thanx

Version	Date	Location	Places available	Book	Next place rate:
Access Advanced 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2007	2008 Sep 24 Wed	Bloomsbury	0	FULL
2003	2008 Oct 8 Wed	Southwark	4	book now	£224	£235
2003	2008 Oct 24 Fri	Bloomsbury	7	book now	£203	£230
2003	2008 Oct 29 Wed	Bayswater	7	book now	£203	£230
2003	2008 Nov 5 Wed	Southwark	7	book now	£190	£224
2003	2008 Nov 21 Fri	Bloomsbury	7	book now	£110	£224
Full Schedule: See all 53 Access Advanced course dates. Bookings currently available until 25th November 2009.

RE: Ms Access to Outlook

by - trainer Carlos gold contributer [413 posts] (2007 Aug 1 Wed, 12:30) Reply

Hi Reza

The reason the button is NOT active is that the only way you can email Access objects is as Attachments.

To send a report as the body of an email you would need to convert it to Word and then send it.

Regards

Carlos

RE: Ms Access to Outlook

by - delegate Reza [10 posts] (2007 Aug 8 Wed, 13:00) Reply

Hi Carol,

I have already tried that suggested way but I was after to send entire body of the report from Access.
Also I have another question, when I creat the form in MsWord and attach it to email as a body, my Check boxes, drop boxes are NOT showing in reciepient email.

Thank you

· Microsoft Access Tighten your Security Controls
· Microsoft Access Courses
· Take an Access Course to Learn About Relational Databases
· Tips for designing databases in Microsoft Access
· How Reorganising Your Data Can Take Your Business to the Next Level

Access tip:

Space marks

It is good practice not i to have space marks for field names as this can lead to problems when using queries or VBA code. It is much better to use an underscore charcter to represent spaces in field names

View all Access hints and tips