Macro: Fill Word with data from Excel

[neda00]

Hi,

I am interested in quickly completing personalized form letters...
basically this form letter just needs an address at the top, an
account number and a dollar value in the text and perhaps a CC
address. I believe this can be fairly straight forward to do and has
likely been done NUMEROUS times. Although I could beat my head trying
to figure it out in the form a VB macro, I'm first asking to see if
someone can give me code used for this and I'll just leverage that and
customize.

Thank you soo soo much in advance and any help would be greatly
appreciated!

Regards,
Neda

 

[Guest]

Hi Neda,

You don't need code, I think... MailMerge should do it. In Tools, go to
Letters and Mailings, then Mail Merge. Follow the wizard. When it comes to
'Select Recipients', navigate to your Excel file.

When it comes to 'Write your letter', you can click on 'more items', which
will let you insert whatever fields you want from your Excel file (not just
contact details; account number etc. are fine too). good luck.

 

[Aden]

Hi Neda,

You don't need code, I think... MailMerge should do it. In Tools, go to
Letters and Mailings, then Mail Merge. Follow the wizard. When it comes to
'Select Recipients', navigate to your Excel file.

When it comes to 'Write your letter', you can click on 'more items', which
will let you insert whatever fields you want from your Excel file (not just
contact details; account number etc. are fine too). good luck.








- Show quoted text -

Well i guess I was right about it being straightforward! thanks for
your help... guess a little playing with the functions would have gone
a long way on this one!!!