how do i mail merge in excel only
 

I want to do mail merge in Excel only ie without having to use Word. How do I
do it?

how do i mail merge in excel only
 

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...o&userid=31779
View this thread: http://www.excelforum.com/showthread...hreadid=515155

how do i mail merge in excel only
 

"FastLiveHelp" wrote:


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...o&userid=31779
View this thread: http://www.excelforum.com/showthread...hreadid=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

how do i mail merge in excel only
 

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

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


--
FastLiveHelp

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