Email Merge?

S@njay · 30 Nov 2006 at 10:02

I feel ashamed to ask such a silly question!

I need to email 50 people, each person has a separate persolanised file.

I dont want to create a new email for each store and add a separate attachment for each person as this would take ages!

Is there the ability to email merge and automatically attach a file attachment for each person? I.e. person 1 gets file 1, person 2 gets file 2 etc...

I am trying to do this with the microsoft office package, anyone know how to do this?

S@njay · 30 Nov 2006 at 11:06

Ok, does anyone know how to execute this?

http://word.mvps.org/FAQS/MailMerge/MergeWithAttachments.htm

Shall i create the macro using excel VB?

Uhtred · 30 Nov 2006 at 11:16

it's not going to be easy

can you host the files on a network share (assuming this is internal mail) and just change the link to each file?

S@njay · 30 Nov 2006 at 12:31

sorted

Just using that code, it was easy as pie! And it works

= less work to do at work, more time to surf ocuk forum!

Uhtred · 30 Nov 2006 at 12:58

S@njay said:
sorted

Just using that code, it was easy as pie! And it works

= less work to do at work, more time to surf ocuk forum!

a worthy cause