I have a report that exports into Word as RTF format. within the report is the customers email address, how can I cut the address from the text and make word open it's Email mode and paste the email address in there and send using a macro?

thanks
Mike

If you are open to using code in place of a macro (Highly recomended) you may want to take a look at this post. You will find an answer there:

Topic: send email from button on a form (http://www.access-programmers.co.uk/ubb/Forum4/HTML/005347.html)


__________________________________________________ __________

The ever increasingly inaccurately named UBB Board List (http://www.traitnet.com/ubblist.asp) for PC Support.
__________________________________________________ __________