Can I mail merge into Excel?
 

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.

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.