Mail Merges into separate files and folders

[Jacquidrys]

Hi,

If you have created a mail merge for a letter, I know there is code to save each letter as a separate file, but is there a way to save each letter as the name of the recipients, then get each document to save in it's own folder of the same name?

I don't really understand VBA and have been asked to look into this so if you know how to do this, can you explain it to me so I can explain it to other people at work.

Thanks

Jacqui

[mdmackillop]

Hi Jacqui,
Welcome to VBAX
Have a look at this KB item (http://vbaexpress.com/kb/getarticle.php?kb_id=290). It shows how to use the mail merge data as the path for saving a new document. If you need help with this, let us know.
Regards
MD

Edit Lucas: Hi Malcolm...link edited ....it had two http://

[Jacquidrys]

Thanks, but that link doesn't work for me. Any ideas?

[lucas]

Try the link now...in Malcolm's post.

[Jacquidrys]

Thanks for that code, definitely a step in the right direction!

Is there any chance you (or someone else) could point me in the right direction for some sort of resource that can help me to teach myself VBA, and for free? I really think I should start with the basics!

Thanks a million! : pray2:

[mdmackillop]

Have a look at our Resources (http://www.vbaexpress.com/resources.php) page

[s?ren]

It sounds like you're having the same problem I had a while back.
Take a look at this:

http://www.vbaexpress.com/forum/showpost.php?p=63936&postcount=13

It works very well for my purposes.

S?ren