merging to email - adding an attachment

[ga66]

Can anyone help please? I know how to mail merge an email, using addresses
etc from an Access database, but now I want to be able to add an attachment
to the email and I can't see how to do this. I'm using Microsoft Office 2003
for XP.

Thanks for your help

 

[Sarah_Lecturer]

If you mean a mail merge in Microsoft Word with an Access Database as your
data source; as far as I am aware it is impossible to add an attachment.

 

[Robert M. Franz (RMF)]

Hello ga

Can anyone help please? I know how to mail merge an email, using addresses
etc from an Access database, but now I want to be able to add an attachment
to the email and I can't see how to do this. I'm using Microsoft Office 2003
for XP.

Mail Merge to E-mail with Attachments (by Doug Robbins)
http://word.mvps.org/faqs/mailmerge/MergeWithAttachments.htm

HTH
Robert

 

[ga66]

Thanks Robert
I'd found this article when I'd searched through responses here a bit more
carefully. When it comes to having to use Visual Basic, I really don't have
the knowledge to do this with any confidence, ie I tend avoid. I was hoping
there might be a more direct way to do it. I'll have to transfer email
addresses into Outlook instead, but the database will change in future and I
was hoping to avoid doing it this way.
Cheers
Gillian

 

[Robert M. Franz (RMF)]

I'd found this article when I'd searched through responses here a bit more
carefully. When it comes to having to use Visual Basic, I really don't have
the knowledge to do this with any confidence, ie I tend avoid. I was hoping
there might be a more direct way to do it. I'll have to transfer email
addresses into Outlook instead, but the database will change in future and I
was hoping to avoid doing it this way.

I can relate to the (VBA) "avoidance" POV myself.

I'm sure there are automated ways to bring the addresses into Outlook
(though, well, that would be automation again ...).

[OTOH, I think I'm glad that it's not too easy to design email merges
with attachments. I'm getting enough mails as it is ... ]

Greetinx
Robert

 

[Graham Mayor]

See http://www.gmayor.com/installing_macro.htm

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP

My web site www.gmayor.com

<>>< ><<> ><<> <>>< ><<> <>>< <>><<>