Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 03-06-2016, 03:18 PM
airwolf airwolf is offline Some Help Needed Windows 7 32bit Some Help Needed Office XP
Novice
Some Help Needed
 
Join Date: Mar 2016
Posts: 8
airwolf is on a distinguished road
Default Some Help Needed

Evening everyone - hoping someone can help / steer me in the right direction.



I manage a call centre team, we are taking some new work on and need a word/excel/vba solution to take the call date and then use that date to populate forms in word (im thinking bookmarks) and also populate some email templates.

Its been 20 years since I even looked at VBA and then it was limited to command buttons.

Ideally i'd like everything in one word document to avoid opening differend documents for different parts of the process.

I have a userfom made already which populates my documents, however part of the process requires my staff to take some location details (countys) and then depedning on which county, we have to email off a request which is pretinent to that county.

I probably need this in a seperate userform, but its how I link this with the data (im guessing in excel) and how can this be used in an email template within my master document?

Any ideas would be gratefully received - Im using word xp & word 03....

Many Thanks
Reply With Quote
  #2  
Old 03-07-2016, 04:55 AM
Charles Kenyon Charles Kenyon is offline Some Help Needed Windows 8 Some Help Needed Office 2013
Moderator
 
Join Date: Mar 2012
Location: Sun Prairie, Wisconsin
Posts: 9,081
Charles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant future
Default

You could have your userform create a new document based on a template for your email and send it.
Reply With Quote
  #3  
Old 03-07-2016, 08:39 AM
airwolf airwolf is offline Some Help Needed Windows 7 32bit Some Help Needed Office XP
Novice
Some Help Needed
 
Join Date: Mar 2016
Posts: 8
airwolf is on a distinguished road
Default

Thanks Charles, think I can make a button within the user form which pops up an email - can I specify which email template to use? Or does this have to be coded within vba?
Reply With Quote
  #4  
Old 03-07-2016, 09:02 AM
Charles Kenyon Charles Kenyon is offline Some Help Needed Windows 8 Some Help Needed Office 2013
Moderator
 
Join Date: Mar 2012
Location: Sun Prairie, Wisconsin
Posts: 9,081
Charles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant future
Default

It has to be coded in the vba. I do not know how to do this. You could have options for the template to use, though, in your Userform with either a drop-down or radio buttons.
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Help with VBA needed OTPM Excel Programming 4 01-23-2014 12:58 PM
Some Help Needed Help Needed MdCadle PowerPoint 1 08-24-2013 09:14 AM
Some Help Needed If or help needed s7y Excel 7 07-31-2013 12:46 AM
If-Then help needed sammipd Mail Merge 1 04-24-2013 04:38 AM
Some Help Needed help needed!!! thunder14 Word 1 10-17-2009 02:57 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 10:08 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