mail merge from excel doc to another excel doc

M

M King

I need to perform something like a mail merge. However, I
am not merging from a list in excel to a document in word
as is common. I need to merge from a list in excel to a
timehseet form that I have created in excel. Any
suggestions?
 
M

Mark Graesser

M
Depending on what you are doing you might be able to use VLOOKUP. This will work even if the lookup table workbook is closed

If you want to print a whole bunch of time cards at the same time then you will probably need to incorporate some VB also

Good Luck
Mark Graesse
(e-mail address removed)

----- M King wrote: ----

I need to perform something like a mail merge. However, I
am not merging from a list in excel to a document in word
as is common. I need to merge from a list in excel to a
timehseet form that I have created in excel. Any
suggestions
 

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

Merging from an Excel file with graphics 1
Paste / Hyperlink multiple Excel Spreadsheets to a Mail Merge Excel Source Document 0
Mail Merge Directory Conditional Page Break 0
Merge Excel file into Word Document 3
Integrating information from Word to Excel (not mail merge) 1
Grouping Names in Mail Merge 0
Windows 2016- Unable to do mail merge with my secondary email accounts 1
Page numbering with Merged Document and IF statements 1

Top