Access 2003 - Need an email button prefilled with info from the fo Randy Star 07.02.2006 17:13:27 I have a form containing three fields that I need to use for an email. "Company", "EmailAddress", and "Program Contact". I'm hoping this is simple - I've never used Visual Basic or anything so I would REALLY appreciate someone walking me through this as if I were the idiot that I really am :-) I just want a button that pops up an email, pre-filled with the email address, a subject like "Welcome to <Company>" (company pulled from the field I mentioned above) and, if possible, pre-filled with our standard text in the body (including the contact name) so I can just click SEND, attach any documents I need to depending on what they need, and be done.

Re: Access 2003 - Need an email button prefilled with info from the fo Steve Schapel <schapel[ at ]mvps.org.ns> 07.02.2006 18:42:47 Randy, Make a macro (from your Database Window, select the Macro tab, and then click New), and enter the SendObject action in the Action column. Press F1 to read the Help topic for this action. This macro will be saved, and assigned on the On Click event property of the Command Button on your form. In the macro arguments (the bit down the bottom of the screen), you can do like this... Object Type, Object Name, etc leave blank. To: =[EmailAddress] Subject: ="Welcome to " & [Company] Message Text: ="Congratulations to " & [Program Contact] & " on your achievement." Edit Message: Yes -- Steve Schapel, Microsoft Access MVP Randy Star wrote: [Quoted Text] > I have a form containing three fields that I need to use for an email. > > "Company", "EmailAddress", and "Program Contact". > > I'm hoping this is simple - I've never used Visual Basic or anything so I > would REALLY appreciate someone walking me through this as if I were the > idiot that I really am :-) > > I just want a button that pops up an email, pre-filled with the email > address, a subject like "Welcome to <Company>" (company pulled from the field > I mentioned above) and, if possible, pre-filled with our standard text in the > body (including the contact name) so I can just click SEND, attach any > documents I need to depending on what they need, and be done.

Re: Access 2003 - Need an email button prefilled with info from th Randy Star 07.02.2006 18:56:28 BEAUTIFUL! Thank you so much :-) "Steve Schapel" wrote: [Quoted Text] > Randy, > > Make a macro (from your Database Window, select the Macro tab, and then > click New), and enter the SendObject action in the Action column. Press > F1 to read the Help topic for this action. This macro will be saved, > and assigned on the On Click event property of the Command Button on > your form. In the macro arguments (the bit down the bottom of the > screen), you can do like this... > > Object Type, Object Name, etc leave blank. > To: =[EmailAddress] > Subject: ="Welcome to " & [Company] > Message Text: ="Congratulations to " & [Program Contact] & " on your > achievement." > Edit Message: Yes > > -- > Steve Schapel, Microsoft Access MVP > > > Randy Star wrote: > > I have a form containing three fields that I need to use for an email. > > > > "Company", "EmailAddress", and "Program Contact". > > > > I'm hoping this is simple - I've never used Visual Basic or anything so I > > would REALLY appreciate someone walking me through this as if I were the > > idiot that I really am :-) > > > > I just want a button that pops up an email, pre-filled with the email > > address, a subject like "Welcome to <Company>" (company pulled from the field > > I mentioned above) and, if possible, pre-filled with our standard text in the > > body (including the contact name) so I can just click SEND, attach any > > documents I need to depending on what they need, and be done. >

Re: Access 2003 - Need an email button prefilled with info from th Susy Lingle 23.05.2006 22:12:01 Steve, does the code change if you are going to do this in Access 2002. I want to do the same thing but in 2002 you don't need the quotes to get the simple text to print. I need to add a field and can't get it to work. ex: Subect: PC Replacement & [Install Date] This prints out exactly as above and doesn't include the Install Date field. "Steve Schapel" wrote: [Quoted Text] > Randy, > > Make a macro (from your Database Window, select the Macro tab, and then > click New), and enter the SendObject action in the Action column. Press > F1 to read the Help topic for this action. This macro will be saved, > and assigned on the On Click event property of the Command Button on > your form. In the macro arguments (the bit down the bottom of the > screen), you can do like this... > > Object Type, Object Name, etc leave blank. > To: =[EmailAddress] > Subject: ="Welcome to " & [Company] > Message Text: ="Congratulations to " & [Program Contact] & " on your > achievement." > Edit Message: Yes > > -- > Steve Schapel, Microsoft Access MVP > > > Randy Star wrote: > > I have a form containing three fields that I need to use for an email. > > > > "Company", "EmailAddress", and "Program Contact". > > > > I'm hoping this is simple - I've never used Visual Basic or anything so I > > would REALLY appreciate someone walking me through this as if I were the > > idiot that I really am :-) > > > > I just want a button that pops up an email, pre-filled with the email > > address, a subject like "Welcome to <Company>" (company pulled from the field > > I mentioned above) and, if possible, pre-filled with our standard text in the > > body (including the contact name) so I can just click SEND, attach any > > documents I need to depending on what they need, and be done. >

Re: Access 2003 - Need an email button prefilled with info from th Steve Schapel <schapel[ at ]mvps.org.ns> 24.05.2006 10:24:28 Suzy, No, regardless of version you would have to do it like this... ="PC Replacement " & [Install Date] In fact, you may also need to control the appearance of the date in this instance, for example... ="PC Replacement " & Format([Install Date],"dd\-mmm\-yy") -- Steve Schapel, Microsoft Access MVP Susy Lingle wrote: [Quoted Text] > Steve, does the code change if you are going to do this in Access 2002. I > want to do the same thing but in 2002 you don't need the quotes to get the > simple text to print. I need to add a field and can't get it to work. > > ex: > Subect: PC Replacement & [Install Date] > > This prints out exactly as above and doesn't include the Install Date field. >

Re: Access 2003 - Need an email button prefilled with info from th Susy Lingle 24.05.2006 18:39:03 No - it puts in exactly what is typed in the subject action arguments of the macro "Steve Schapel" wrote: [Quoted Text] > Suzy, > > No, regardless of version you would have to do it like this... > ="PC Replacement " & [Install Date] > > In fact, you may also need to control the appearance of the date in this > instance, for example... > ="PC Replacement " & Format([Install Date],"dd\-mmm\-yy") > > -- > Steve Schapel, Microsoft Access MVP > > Susy Lingle wrote: > > Steve, does the code change if you are going to do this in Access 2002. I > > want to do the same thing but in 2002 you don't need the quotes to get the > > simple text to print. I need to add a field and can't get it to work. > > > > ex: > > Subect: PC Replacement & [Install Date] > > > > This prints out exactly as above and doesn't include the Install Date field. > > >

Re: Access 2003 - Need an email button prefilled with info from th Steve Schapel <schapel[ at ]mvps.org.ns> 24.05.2006 19:36:38 Susy, Can you show us please exactly what did you type in the macro argument? -- Steve Schapel, Microsoft Access MVP Susy Lingle wrote: [Quoted Text] > No - it puts in exactly what is typed in the subject action arguments of the > macro >