By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
458,044 Members | 1,296 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 458,044 IT Pros & Developers. It's quick & easy.

Email from access 2003

P: 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.

Aug 26 '08 #1
Share this Question
Share on Google+
1 Reply

P: 167
Expand|Select|Wrap|Line Numbers
  1. Private Sub MailReport_Click()
  3.     Dim stDocName As String
  5.     stDocName = "rptYourReport"
  6.     DoCmd.SendObject acReport, stDocName
  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

Post your reply

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