My data input form is created using Excel and my data source is also
in Excel, how am I able to feed all the data into the form by using
Marco/VBA? My present solution is to use the copy and paste function
which is very time consuming. So if I have 100 data with my source
then I have to do 100 times of copy and paste. In short are there any
ways for me to utilize some sort of Mail Merge function with Excel.
Help would be greatly appreciated.

there is no mail merge function in Excel, but you could write a macro to
loop through your data, and populate your form on record at a time (I assume
you want to print it).

--
Regards,
Tom Ogilvy


"Sherwin" wrote in message
om...
My data input form is created using Excel and my data source is also
in Excel, how am I able to feed all the data into the form by using
Marco/VBA? My present solution is to use the copy and paste function
which is very time consuming. So if I have 100 data with my source
then I have to do 100 times of copy and paste. In short are there any
ways for me to utilize some sort of Mail Merge function with Excel.
Help would be greatly appreciated.

Hi Tom,

You're right, I also need to print out the form, do you have any idea
how to write the macro and integrate it into the form?

Thanks,
Sherwin



*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!