Auto generate text in e-mail from Form

[Runes]

Hi all​

​

I’m looking for a vba code that can auto generate the text in an e-mail based on cells/textbox in the form you are looking at. When you click on the e-mail button, the email will put in fixed text + [data from name of Cell1(textbox1) in table1/Form1] in subject field automatically. And the same in the message text.​

Thanks

 

[pbaldy]

Generally:

Something = "Fixed text here" & Me.Textbox1 & "more fixed text here

 

[Runes]

I'm a newbie in VBA coding, it is possible to help me with the entire code. The e-mail adresses I will send to will be in the vba code.

 

[Minty]

Have a look at this thread http://www.access-programmers.co.uk/forums/showthread.php?t=160598

It has code and outlines some other things that may be of help.

 

[Gasman]

Have a look at how I created the email body (mine is in html, yours might not need to be, which would make it easier to create) from an Outlook template here.

http://www.access-programmers.co.uk/forums/showthread.php?t=282557&highlight=email

Built from bits and bobs on the net and help from this forum.

It should give you a start?