Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 10-17-2017, 07:55 AM
phorsley phorsley is offline Submit Button Req that populates email address Mac OS X Submit Button Req that populates email address Office 2016
Novice
Submit Button Req that populates email address
 
Join Date: Oct 2017
Posts: 5
phorsley is on a distinguished road
Default Submit Button Req that populates email address

Hi,



New to forum.

I have been asked to place a submit button on a word file so when this is clicked it opens outlook attaches the word file to a new email and adds the recipients address, I've managed to get the first 2 requests to work using the macro below but I can't get it to populate the email address, any help please as I'm all googled out. I've also got
another macro to run that attaches the word file and sends the email in the background but I would like the user to hit the send button manually.

Thanks

Paul

Private Sub CommandButton1_Click()
Options.SendMailAttach = True
ActiveDocument.SendMail
End Sub
Reply With Quote
  #2  
Old 10-17-2017, 04:50 PM
macropod's Avatar
macropod macropod is offline Submit Button Req that populates email address Windows 7 64bit Submit Button Req that populates email address Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

Quote:
Originally Posted by phorsley View Post
I have been asked to place a submit button on a word file
That - and your code - implies the use of an ActiveX command button, but ActiveX controls have never been supported on Macs.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Infopath PDF attached to Form not showing in Email Submit CliffEstel Misc 0 09-20-2016 11:04 AM
Submit to Email Command Button rob7676 Word VBA 0 08-20-2015 05:05 AM
Submit Button Req that populates email address Macro for submit email AmyScott Excel Programming 2 12-29-2014 09:28 AM
Submit Button Req that populates email address VBA Code for a SUBMIT button in a Word form BlueMax Word VBA 3 08-07-2013 06:26 AM
Submit Button Req that populates email address Email submit that... antipelagian Word VBA 3 02-12-2013 12:07 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 08:11 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft