Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Use Letter Template but not Mail Merge
I want to know if something is possible. Presently have excel spreadsheet
table containing a number of referenced records (at present 700) as below |Ref|Date|Name|etc..... Want to know if there is a way to do a kind of merge to a standard letter of the data but only on a case by case basis rather than merging the whole datasource into word. My ideal solutions would be something where you highlight the row and press a button and hey presto. Problem is dont know if can be done or how to go about. Another reason i dont want to mail merge is due to lack of computer skills of others that will be using it and trying to navigate to the correct ref. Thanks Adrian Harding |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Use Letter Template but not Mail Merge
Yes you can select individual "records".
Adrian Harding wrote: I want to know if something is possible. Presently have excel spreadsheet table containing a number of referenced records (at present 700) as below |Ref|Date|Name|etc..... Want to know if there is a way to do a kind of merge to a standard letter of the data but only on a case by case basis rather than merging the whole datasource into word. My ideal solutions would be something where you highlight the row and press a button and hey presto. Problem is dont know if can be done or how to go about. Another reason i dont want to mail merge is due to lack of computer skills of others that will be using it and trying to navigate to the correct ref. Thanks Adrian Harding |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Use Letter Template but not Mail Merge
Have a look at John Walkenbach's "mail merge without Word"
http://www.j-walk.com/ss/excel/tips/tip92.htm Might do what you want. Gord Dibben MS Excel MVP On Wed, 7 Nov 2007 19:47:40 -0000, "Adrian Harding" wrote: I want to know if something is possible. Presently have excel spreadsheet table containing a number of referenced records (at present 700) as below |Ref|Date|Name|etc..... Want to know if there is a way to do a kind of merge to a standard letter of the data but only on a case by case basis rather than merging the whole datasource into word. My ideal solutions would be something where you highlight the row and press a button and hey presto. Problem is dont know if can be done or how to go about. Another reason i dont want to mail merge is due to lack of computer skills of others that will be using it and trying to navigate to the correct ref. Thanks Adrian Harding |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Code launches Mail Merge but disables the Mail Merge | Excel Discussion (Misc queries) | |||
doing mail merge with excel the first letter in zip code is missi | Excel Discussion (Misc queries) | |||
How do I set up Mail Merge using an Excel template (an invoice) ? | Excel Discussion (Misc queries) | |||
Merge address in XL to Word letter template | Excel Discussion (Misc queries) | |||
in mail merge can you add something in to the body of the letter | Excel Discussion (Misc queries) |