Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Macro needed for form filling and sending

Status
Not open for further replies.

kdr1974

IS-IT--Management
Jul 18, 2008
13
GB
Hi All

I have a form in Word that I wish people to complete before pressing a button which will send the completed form back to a specific email address as an attachment.

I have created a macro and toolbar button which saves the form, opens new email and attaches the file but cannot get the email recipient name to prepopulate and then send - can anyone help please?

Thanks
Kyle
 
Hi,

"I have created a macro...but cannot get the email recipient name to prepopulate and then send "

When I asked you to repost in this forum, I also asked you to post the code, unless you want us to guess at what method you're using to do this.

The quality of an answer will be in proportion to the quality of the information you provide.

Skip,

[glasses]Just traded in my old subtlety...
for a NUANCE![tongue]
 
Sub MailBCST()
'
' MailBCST Macro
' Macro recorded 11/28/2008 by User
'
ActiveDocument.SendMail
End Sub

This is all I have - sorry, I really don't understand VBA...
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top