Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 10-18-2014, 08:49 PM
cs225 cs225 is offline Data gathering from varied sources for different outcome letters Windows XP Data gathering from varied sources for different outcome letters Office 2010 64bit
Novice
Data gathering from varied sources for different outcome letters
 
Join Date: Oct 2014
Posts: 2
cs225 is on a distinguished road
Default Data gathering from varied sources for different outcome letters

Hi All

I am looking to be more effective during a lengthy period at work creating letters to customers. I have to gather data (acronyms and shorthand text with dates) from various systems before organising findings in date order. I then make a decision whether or not the correct process has been followed relating to an incident. After this I'm then required to translate the data I gathered earlier on and address in a letter to customers.

I have meanings for all of the acronyms than may arise on various systems and I have built up paragraphs that relate to the rationale behind the business activity so a customer would understand how the various acronyms impacted the service they received.

Could I please ask for some advise on how to be speed up this process using MS word and Excel 2010, possibly access? What functions would I need to engage from those applications? At the moment I’m an absolute beginner and need to get my head around things and would really appreciate some guidance on what I would need to do to achieve in MS office.

I typically issue letters that are about 3 pages long. One page of standard text to every customer, 1 page of text containing about 2 or 3 paragraph clusters relating to the type of incident they experienced (already prepared wording); then a couple of paragraphs translating the acronyms that were assigned on their profiles in order of the dates they took place.

I'd like for the data I gather to be tidied up in an automated way if possible. I start by copying and pasting it into notepad from each system initially but the dates are in order only from each system.
I don’t have any flexibility with gathering the data as my system access is fairly limited
Examples of the data I gather might be:
System 1 - field a: informs me of incidents types and date of incident. I have wording for each type and have to input dates in Word in the format of ‘14 January 2014’ rather than 14/1/13.
12/1/13 (blank meaning status clear)
12/1/13 Gs
10/1/13 GP
6/1/13 Gs
*&**System 1 – field 2: informs me of service usage via mediums. For example Qwe (postal), Asd (telephone), zxc (internet)
Qwe: 13/10/14
Asd: 15/10/14
Zxc: 13/10/14
From system 1 I’d like to be able to utilise my pre prepared paragraphs to explain;
GS 6/1/13=An engineer reconfigured your settings on 6 January. Gp 10/1/13=Your service was interrupted on 10 January 2013. 12/1/13 Gs =An engineer reconfigured your settings on 12 January. 12/1/13 blank= Access to your service has been uninterrupted since 12 January.
*I can see that you have since used your service successfully by postal, phone and internet since
**Only to be included if all dates in field 2 are greater than field 1. I’d like to be more medium specific but feel this take is already very complex for me at the moment.

System 2
Tony call office to ask why not working 7/10/13
Annoyed again having to wait for us 7/10/13
Escalated issue to correct dept told cust 7/10/13
Will update later in week 7/10/13
Cust service unpaid awaiting confirm 8/10/13
From accounts no credit received 10/10/13
Confirm from accounts cust stopped 10/10/13
Payments 2 months ago, do not resume 10/10/13
Service until paid in full with confirmation 10/10/13
From accounts dept 10/10/13
Cust called said payment sent, promised will 12/10/13
Reactivate service after call. 12/10/13
Cust angry service not reactivate needs answer 14/10/13
Accounts inform service blocked, no confirm 17/10/13
Received from cust creditor, acc to remain blocked 17/10/13
Customer call wants answer and service on 25/10/13
System 2 shows me notes added shorthand onto customer profile. Those I can’t quite prepare wording for beforehand to auto populate later. I’d really like to see them in somewhere ordered with data from other systems by date so I can understand the sequence of events.


System 3
Again in a different format;
Date, time, location, units, outcome
Date, time, location, units, outcome
Date, time, location, units, outcome
Date, time, location, units, outcome
Date, time, location, units, outcome
I’d like to populate this within the letters from pre prepared parargahs. Can I create sentences that pull the data from excel or access for this?
In short I think I’m trying to more easily populate and then translate data. Currently I highlight copy then pasted from fields on screen in various systems into notepad were I need to go back and forth to see what took place and when.
I’d like to organise entries in date order so I can see events logically in date order.
Communicate from word letters more efficiently using the data I gathered with prepared customer friendly wording., several letters at a time.
Please share comments freely. I have tried discussing this with many of my colleagues who all say it is not possible yet we are all quite junior and low in ms office skills.

I hope to be able to create a method that has an entry screens for data sets from each system that populates my own database, presents gathered data from each systems in and presents clearly in data order from all data on requested customer, generates letter with data gathered.
Reply With Quote
  #2  
Old 10-19-2014, 01:14 AM
gmayor's Avatar
gmayor gmayor is offline Data gathering from varied sources for different outcome letters Windows 7 64bit Data gathering from varied sources for different outcome letters Office 2010 32bit
Expert
 
Join Date: Aug 2014
Posts: 4,101
gmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud of
Default

I have read through your message several times and, without any knowledge that comes from working with your data, I still haven't any idea what it is that you are trying to do.

You refer to 'systems' without any indication what you mean by 'systems'. It is impossible to create a function to work with 'systems' when we don't know what those 'systems' are. Are they documents, Excel work books, text files, some form of database format?

It is relatively straightforward to insert texts into a document, provided you know three things. 1. What determines which text to insert, and 2. Where the text is to be inserted. 3. Where the text to be inserted comes from.

To give you some insight into what might be possible, you should look at AutoCorrect (which can be used to replace a typed 'acronym' with any amount of text etc.) or you could look at something like http://www.gmayor.com/Boiler.htm which will allow you to work with texts in the form of separate documents.

It is also possible to create processes that use Userforms to select or enter information into a document. Many automated templates work on this principle but as a beginner you are going to have to dig deep to get to grips with the VBA required - see http://www.gmayor.com/Userform.htm and http://www.gmayor.com/Userform_ComboBox.html and when comfortable with those processes see http://gregmaxey.com/Create_and_employ_a_UserForm.htm for a more in depth explanation.

The thing to remember is that macros are not intelligent. They can't make decisions for you. They can only respond with choices based on the information with which you provide them.
__________________
Graham Mayor - MS MVP (Word) (2002-2019)
Visit my web site for more programming tips and ready made processes www.gmayor.com
Reply With Quote
  #3  
Old 10-19-2014, 06:23 AM
cs225 cs225 is offline Data gathering from varied sources for different outcome letters Windows XP Data gathering from varied sources for different outcome letters Office 2010 64bit
Novice
Data gathering from varied sources for different outcome letters
 
Join Date: Oct 2014
Posts: 2
cs225 is on a distinguished road
Default

Hi Gmayor,

Thank you for your reply. The systems I'm referring to are in house it systems that I have to copy and and paste from and sometimes request paper based reports so my data collection is method is already fixed. I can't pull data as I understand, only copy it similar to the formats I typed in the examples. To hazard a guess; how long may this take for a relatively unskilled office worker to figure out and implement? Are these tasks advanced?
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Adding a cropped .pdf, weird outcome! Majten Word 0 12-14-2012 06:07 AM
Data gathering from varied sources for different outcome letters Varied Print Edge Requirements (A4 and A3 in same document) charlie1979 Word 1 01-27-2012 02:10 PM
Data gathering from varied sources for different outcome letters Combining word documents with sources yoel Word 3 07-21-2011 10:45 PM
When Printing a file Sources/Details included BigTunz Word 0 03-01-2010 01:24 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 06:04 PM.


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