Copying excel data to word using a macro

davidandrews8 · Mar 14, 2001

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 · Mar 14, 2001

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 · Mar 14, 2001

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

Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Copying excel data to word using a macro

davidandrews8

Technical User

DarkSun

Programmer

dsi

Programmer

Similar threads

Part and Inventory Search

Sponsor