Generate Email

[James Mullan]

Hi

Can anyone advise how I can generate an email from access? I want the user
to be able to click a button which will open an email template in outlook and
populate with data from specified tables and columns.

Thanks

James

 

[Alex Dybenko]

Hi,
have a look at docmd.sendobject

--
Best regards,
___________
Alex Dybenko (MVP)
http://accessblog.net
http://www.PointLtd.com

 

[James Mullan]

Thanks Alex, I've got the basics of this sorted. Do you know how I could call
the the contents of a field in the current record and place them in the 'To'
field of the message?

Thanks

James

 

[Alex Dybenko]

Hi,
say you have a textbox txtTo, then code behind button's click event on there
same form will be:

docmd.sendobject acSendTable,"MyTable",,me.txtTo


--
Best regards,
___________
Alex Dybenko (MVP)
http://accessblog.net
http://www.PointLtd.com

 

[James Mullan]

brilliant - thanks Alex

another q... (and don't know if this is possible)

within the text string of the message section, is it possible to insert
items in a similar way?

thanks

James

 

[Alex Dybenko]

Hi,

you can add it as body parameter. Also you can send table as text like here:
http://maug.pointltd.com/access/Queries/TipDetail.asp?TipID=71

--
Best regards,
___________
Alex Dybenko (MVP)
http://accessblog.net
http://www.PointLtd.com

 

[James Mullan]

thanks Alex - I'm still a little new to VBA - could you explain how I would
do this? what syntax I would use etc? would I set this up within the text
string of the message body?

 

[Alex Dybenko]

just the same way you do with subject:

docmd.sendobject acSendTable,"MyTable",,me.txtTo, me.txtBodyText

--
Best regards,
___________
Alex Dybenko (MVP)
http://accessblog.net
http://www.PointLtd.com