| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Write a letter
Is it possible for excel to auto write a letter using data that has been entered on a worksheet.
For example if the cells a1:a6 are designated for name inputs on the worksheet and cells a7 are designated for action a8 for location a1="tom" a2="dick" a3="harry" A4="" A5="" & a6="" a7="drive" a8="london" Could vba code write "dear tom,dick & harry" please drive to london and so on down a list of inputs. If i can have a starting point I think I should be able to develop the code!?!?? Thanks for any suggestions Cheers Nobby |
|
#2
Posted to microsoft.public.excel.setup
|
|||
|
|||
|
Write a letter
Maybe you can use this from Debra Dalgleish's site:
http://contextures.com/xlForm03.html nobbyknownowt wrote: Is it possible for excel to auto write a letter using data that has been entered on a worksheet. For example if the cells a1:a6 are designated for name inputs on the worksheet and cells a7 are designated for action a8 for location a1="tom" a2="dick" a3="harry" A4="" A5="" & a6="" a7="drive" a8="london" Could vba code write "dear tom,dick & harry" please drive to london and so on down a list of inputs. If i can have a starting point I think I should be able to develop the code!?!?? Thanks for any suggestions Cheers Nobby -- nobbyknownowt -- Dave Peterson |
|
#3
Posted to microsoft.public.excel.setup
|
|||
|
|||
|
Write a letter
A start could be having a look here at John Walkenbach's site.
http://www.j-walk.com/ss/excel/tips/tip92.htm Downloadable workbook with code for mailmerge using Excel only. Gord Dibben MS Excel MVP On Tue, 6 Mar 2007 16:18:03 +0000, nobbyknownowt wrote: Is it possible for excel to auto write a letter using data that has been entered on a worksheet. For example if the cells a1:a6 are designated for name inputs on the worksheet and cells a7 are designated for action a8 for location a1="tom" a2="dick" a3="harry" A4="" A5="" & a6="" a7="drive" a8="london" Could vba code write "dear tom,dick & harry" please drive to london and so on down a list of inputs. If i can have a starting point I think I should be able to develop the code!?!?? Thanks for any suggestions Cheers Nobby |
|
#4
|
|||
|
|||
|
Brilliant as usual. thanks for the guidance
cheers Nobby |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| New Validation option to format 1st letter as Capital letter | Excel Discussion (Misc queries) | |||
| Default Capital letter for 1st letter of a word | Excel Discussion (Misc queries) | |||
| i need to write a letter of resignation | Excel Discussion (Misc queries) | |||
| Help to write a formula using a letter value and a number value | Excel Worksheet Functions | |||
| column header changed from letter to number, how return to letter | Excel Discussion (Misc queries) | |||
Linear Mode
