email merge with attachments

[Nicola]

Hi,
Im trying to send attachments with emails using mail
merge. I know that this isnt possible to do using outlook
so I wondered if there was a way to merge all emails
without sending them straight away?
Can I send merged emails to a folder then add the
attachments before sending them?
Many thanks
Nicola

 

[Doug Robbins - Word MVP]

Hi Nicola,

See the article "Mail Merge to E-mail with Attachments" at

http://www.mvps.org/word/FAQs/MailMerge/MergeWithAttachments.htm

Please post any further questions or followup to the newsgroups for the
benefit of others who may be interested. Unsolicited questions forwarded
directly to me will only be answered on a paid consulting basis.

Hope this helps
Doug Robbins - Word MVP

 

[Guest]

Thanks for this Doug. I got as far as creating a word
document but dont know how to do macros. Do you know of a
site which will talk me precisely through every step?
Thanks again
Nicola

 

[Doug Robbins - Word MVP]

Hi Nicola,

See the article "What do I do with macros sent to me by other newsgroup
readers to help me out?

I don't know how to install them and put them to use" at:

http://www.mvps.org/word/FAQs/MacrosVBA/CreateAMacro.htm

Please post any further questions or followup to the newsgroups for the
benefit of others who may be interested. Unsolicited questions forwarded
directly to me will only be answered on a paid consulting basis.

Hope this helps
Doug Robbins - Word MVP

 

[Nicola]

Hi Doug,
I managed to run the macro so it attaches the right
document to the emails but the email itself is blank
without the personalised email merge- can you tell me what
im doing wrong?
Thank you
Nicola

 

[Doug Robbins - Word MVP]

Hi Nicola,

Do you have the document created by the mailmerge as the active document
when you are executing the macro?

These lines of the code

Source.Sections.First.Range.Cut
Documents.Add
Selection.Paste
Set oItem = oOutlookApp.CreateItem(olMailItem)
With oItem
.Body = ActiveDocument.Content

Create a new document for each record that contains the content of the
relevant section of the document created by the execution of the mailmerge.
That new document then becomes the body of the email message that is sent.

If you want to include a subject line, add the following command after .Body
=

.Subject = "This is the subject"

Please post any further questions or followup to the newsgroups for the
benefit of others who may be interested. Unsolicited questions forwarded
directly to me will only be answered on a paid consulting basis.

Hope this helps
Doug Robbins - Word MVP

 

[Guest]

Hi Doug- thanks a million for this- ive cracked it now. I
was doing the mail merge as an email merge - not realising
the macro converted resulting the word document to an
email.
Its saved me days of work!!
Thanks so much
Nicola