Copying excel data to word using a macro

[davidandrews8]

I want to be able to have a macro in the excel system I have made, which will copy accross the current data from a sheet to a word document (this can be in the form of a picture, as the data does not need to be used again).

I would also like the same word document to be linked to an Access table so I can have the addresses of each person on the form (Like in a mail merge)

 

[DarkSun]

David,
This sounds like quite a big job to setup. Do you want someone to do it all for you or would you like some guidance through the different tasks.

If you want me to do it for you:
You need to give more detail and send some example data like database,excel sheet and word document.
My email address is dark_suns@lycos.com

If you want some guidance we can go through it step by step.

 

[dsi]

Could we keep the discussion in this thead for all to benefit from?