Mail Merge with Excel?

  • Thread starter Thread starter Sherwin
  • Start date Start date
S

Sherwin

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).
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Open a word mail-merge document from Excel VBA 1
Best solution to merge multiple Outlook contacts easily 2
Mailmerge in Excel? 1
Using VBA to automate printing with mail merge 1
Send mail code from Ron 1
Copy value from changing cells without VBA 1
Mail Merge source Access Database using Excel VBA 1
mail merge 2

Back
Top