| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Can I mail merge into Excel?
See if this site will help you:
http://www.pcanswers.co.uk/tutorials...ectio nid=782 " wrote: Hi, What I need to do is open Excel from within a .NET 2.0 application and mail merge some data in (without any user action in Excel) to produce a formatted sales invoice. While some of the data is fixed and predictable (eg, name, phone number), some of it will be variable in nature, ie, the number of items on the statement. Firstly, is it possible, having invoked Excel from another application, to get it to mail merge the data you supply it with? Secondly, if (1) is possible, how can I reference variable data? The data will ideally be passed in is as a DataTable, but I can place it in an Access table if that is the only way forward. If the "obvious" response is to do this in Word, the reason for Excel is that the client has supplied numerous documents in Excel and we don't want to convert them or ask the client to do so. TIA, dave. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| merge two excel files like in word mail merge | Excel Discussion (Misc queries) | |||
| How do I do an e-mail mail merge using an Excel spreadsheet? | Excel Worksheet Functions | |||
| Code launches Mail Merge but disables the Mail Merge | Excel Discussion (Misc queries) | |||
| mail merge excludes my headers and critical data in Word merge | Excel Discussion (Misc queries) | |||
| Can I merge an excel list to an excel sheet like mail merge in wor | Excel Programming | |||
Threaded Mode
