Click here for important information about

Excel Data to Word (Letter)

Mstest / Awrdacpi
June 29, 2012 at 07:56:35
Specs: Microsoft Windows XP Professional, 2 GHz / 958 MB

Hope you could help me. I am planning to create a macro wherein when I run the macro all the data I have in excel will be converted into a letter (word format).

Example i have data in excel
Type First Name Last Name Address Promo type
ddo Kevin Rogers Manila Discount
rtp Rachel Cruz Manila Free

The result in word should be
Kevin Rogers

Dear Mr.Rogers,

Thank you for availing our promo.
<promo type>

Is it possible that it will run different letter in one macro using the type in the first column?

Thanks :)

See More: Excel Data to Word (Letter)

June 29, 2012 at 10:10:32
It sounds like you want to use Mail Merge in Word to pull data from Excel instead of using an Excel macro to push data into Word.

Look up Mail Merge in the help files, or better yet, DAGS for some videos and other help sites.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

Report •
Related Solutions

Ask Question