|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
March 6th, 2007, 04:18 PM
posted to microsoft.public.excel.setup
|
|||
|
|||
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 -- nobbyknownowt 
|
|
#2
March 6th, 2007, 06:48 PM
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
March 6th, 2007, 08:18 PM
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
March 7th, 2007, 03:45 PM
posted to microsoft.public.excel.setup
|
|||
|
|||
|
Write a letter
Brilliant as usual. thanks for the guidance cheers Nobby -- nobbyknownowt
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
