Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 04-20-2014, 03:26 PM
barters1972 barters1972 is offline Help with macro to save / email / close form Windows 7 64bit Help with macro to save / email / close form Office 2010 32bit
Novice
Help with macro to save / email / close form
 
Join Date: Apr 2014
Location: Sussex
Posts: 1
barters1972 is on a distinguished road
Default Help with macro to save / email / close form

Hi.

I have created a word form that will be used for requesting annual leave, the fields will be completed and then emailed to a specific address, it will then have the remaining fields completed before being emailed back to the original sender. I have included two submit buttons on the form for these functions and have managed to find the code from researching various websites that attach the form to an email with the specific address and the authorise. however, i don not understand vba and need some help. when i send the form it does not save the completed fields unless i save first, is it possible to do this without saving the form as i want the original to remain blank? also is it possible to close the application on clicking the submit button so the user knows it has been sent? I then need the authoriser who has received the form and completes the remaining fields before clicking the authorise button that will then attached the completed form to an email before saving and closing the form to a specific location.

I hope someone can assist.

thank you in advance

Im using Word 2010 32bit & Outlook 2010
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Help with macro to save / email / close form a save-as prompt every time i try to close my session willy0625 Word 5 01-08-2014 04:49 PM
Help with macro to save / email / close form Format of Header changing after save and close shen_27 Word 4 03-19-2013 11:41 AM
excel 2010 not deleting tmp files on save/close willbaker13 Excel 0 04-26-2012 05:08 PM
Help with macro to save / email / close form How to close an email account and save info? Srcurran2201 Outlook 1 01-27-2012 07:09 PM
Help with macro to save / email / close form Auto Format Upon Save/Close gamefish Word VBA 1 12-08-2011 07:17 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 10:22 PM.


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