A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Using Forms
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Emailing a form as an attachment



 
 
Thread Tools Display Modes
  #1  
Old April 23rd, 2008, 08:09 PM posted to microsoft.public.access.forms
Linda
external usenet poster
 
Posts: 661
Default Emailing a form as an attachment

Hi,

I have a form that our users fill out and then will have to email. RIght
now I only have one object on the form emailed to me. But I would like the
whole form to be emailed to me for that current record. Is there any way of
doing this?

Thanks
Linda
  #2  
Old April 24th, 2008, 02:01 AM posted to microsoft.public.access.forms
Daniel Pineault
external usenet poster
 
Posts: 658
Default Emailing a form as an attachment

You could build a string based on the form controls and use the SendObject
method to email it.

For instance

sbody=Me.ControlName1 & vbcrlf & vbcrlf & Me.ControlName2

DoCmd.SendObject
",,,"YourEm ailSubject",sbody

or an alternative would be to create a report based on the form, print it to
a pdf (using lebans rpt2pdf http://www.lebans.com/reporttopdf.htm) and then
email that using Outlook automation (see
http://msdn2.microsoft.com/en-us/lib...ageusingaccess)


Here are a few other postings on the subject to checkout:
http://www.microsoft.com/communities...r=US&sloc=&p=1
http://articles.techrepublic.com.com...7-6160599.html
http://www.utteraccess.com/forums/sh...Number=1624036
http://www.utteraccess.com/forums/sh...Number=1216322
--
Hope this helps,

Daniel Pineault
For Access Tips and Examples: http://www.cardaconsultants.com/en/msaccess.php
If this post was helpful, please rate it by using the vote buttons.



"Linda" wrote:

Hi,

I have a form that our users fill out and then will have to email. RIght
now I only have one object on the form emailed to me. But I would like the
whole form to be emailed to me for that current record. Is there any way of
doing this?

Thanks
Linda

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 04:49 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.