how do i mail merge in excel only

F

FastLiveHelp

Hello E,

Where would your letter template be and what would you expect the
format of the output to be?
 
E

E

FastLiveHelp said:
Hello E,

Where would your letter template be and what would you expect the
format of the output to be?


--
FastLiveHelp

Database, website, and application developer
------------------------------------------------------------------------
FastLiveHelp's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=31779
View this thread: http://www.excelforum.com/showthread.php?threadid=515155

Hi FastLive Help,
What I am essentially doing is creating a database in Excel with fields such
as "Payee", "Address", "City", "Amount", etc. The output will be a check
requisition form in Excel that will have all these details in the appropriate
fields without any maunal keying. I would like the database in one tab and
the check req output in another tab.
Is this possible? I searched the internet and the only possibility I saw was
a PA Tools software.

Thanks for your help.
E
 
F

FastLiveHelp

Yes that's possible. It would be done with VBA. You would simply need
program that reads the sheet with your list of information and create
the output sheet according to the layout you specify.

I offer custom Excel services like this on my website if you'd like i
done for you
 
Top