473,324 Members | 2,511 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,324 software developers and data experts.

Email from access 2003

vs2k8
13
Hello guys,

I got this tricky stuff from my boss and I am not sure I can achieve this using access 2003.

I have this request form to be filled in by user and should have button Email which will attach the form to Novell groupwise and then user just fill the user id and pre defined subject Form requested and in body "Dear Customer,
Please check the form and let us know any changes to be made. Thanks".

I dont know how to proceed the code using VBA.So if anyone can help me will be great favor to me.

I got that if you fill unbound record and just right click and send it, it gets attached to the groupwise in PDF format with no subject and no body.Issue is that my form is table based, so if i try to do this method it will attach all the request form which are in the database.So any suggestion are welcome.

Thanks in advance.

-V
Aug 26 '08 #1
1 1252
hjozinovic
167 100+
Expand|Select|Wrap|Line Numbers
  1. Private Sub MailReport_Click()
  2.  
  3.     Dim stDocName As String
  4.  
  5.     stDocName = "rptYourReport"
  6.     DoCmd.SendObject acReport, stDocName
  7.  
  8. End Sub
First create Report that should be e-mailed to who ever you want.
Than create button using wizard (Report operations->Mail report).
In code line 6. type comma "," at the end to open the context and fill in the info.
Aug 27 '08 #2

Sign in to post your reply or Sign up for a free account.

Similar topics

11
by: Wolfgang Kaml | last post by:
Hello All, I have been working on this for almost a week now and I haven't anything up my sleeves anymore that I could test in addition or change.... Since I am not sure, if this is a Windows...
1
by: Lauren Quantrell | last post by:
I've been using docmd.sendobject to send e-mail using an Access 2K front end for a customer running 250 workstations. The client now has combinations of Access2K, AccessXP, Access 2003 running...
10
by: Lauren Wilson | last post by:
Ok I have searched the MS website for info on this. I am totally confused. If I want to deploy an Access 2003 app and allow my users to run it using Access 2003 Runtime, where do I get the...
47
by: ship | last post by:
Hi We need some advice: We are thinking of upgrading our Access database from Access 2000 to Access 2004. How stable is MS Office 2003? (particularly Access 2003). We are just a small...
2
by: acewood1 | last post by:
I've done some searching in the archives but can't seem to find an easy answer as to how to send a Groupwise email through Access 2003. I just need to open a new email and populate the "To:" line...
7
by: Marcin | last post by:
Hello all! A few years ago I created a form with button which let me send an email with an attachment. It was created in Access 97. Now I would like to move this application into Access 2003....
2
by: Terry Olsen | last post by:
I'm running on Windows Server 2003, Exchange 2003, ASP.NET (Framework 1.1) I can send mail using an email client, telnetting in to the SMTP port and manually sending the email, but when I try to...
52
by: Neil | last post by:
We are running an Access 2000 MDB with a SQL 7 back end. Our network guy is upgrading to Windows Server 2003 and wants to upgrade Office and SQL Server at the same time. We're moving to SQL Server...
10
by: Mike Charney | last post by:
Is there a simple way to send SMTP email from Access VBA? Mike m charney at dunlap hospital dot org
10
by: Walshi | last post by:
Hi all, I'm a relative newby to access and VBA etc. My forms and tables etc are working great and saving lots of time...However... I have two databases with the exact same table format. I want...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.