I'm working in Word and I want to send a mail merged email with an attachment
- but there doesn't seem to be a function for this. My source file is a list
as an Excel Worksheet, and I want to send a word document attached to emails
to all the email addresses on the list. I've also tried importing the XL list
into my Outlook address book but it's not letting do it because I've not
defined a 'range' in the XL file - I don't know how to do that eaither!! _
Help!!!

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

http://word.mvps.org/FAQs/MailMerge/...ttachments.htm


--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP
"Noddy of Nottingham" Noddy of wrote
in message ...
I'm working in Word and I want to send a mail merged email with an
attachment
- but there doesn't seem to be a function for this. My source file is a
list
as an Excel Worksheet, and I want to send a word document attached to
emails
to all the email addresses on the list. I've also tried importing the XL
list
into my Outlook address book but it's not letting do it because I've not
defined a 'range' in the XL file - I don't know how to do that eaither!! _
Help!!!

See the article prepared by fellow MVP Doug Robbins at
http://word.mvps.org/FAQs/MailMerge/...ttachments.htm

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org




Noddy of Nottingham wrote:
I'm working in Word and I want to send a mail merged email with an
attachment - but there doesn't seem to be a function for this. My
source file is a list as an Excel Worksheet, and I want to send a
word document attached to emails to all the email addresses on the
list. I've also tried importing the XL list into my Outlook address
book but it's not letting do it because I've not defined a 'range' in
the XL file - I don't know how to do that eaither!! _ Help!!!

this is Supriya
i found this article very informative and happend to learn a new point
today. thans for the support and help
would you help me in suggeting an option to send an seperate subjet line for
each mail in the mail merge process. you can even check my question logged.

"option to merge seperate subject for email in the merge" from subject line
in email.


regards
Supriya V
"Doug Robbins" wrote:

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

http://word.mvps.org/FAQs/MailMerge/...ttachments.htm


--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP
"Noddy of Nottingham" Noddy of wrote
in message ...
I'm working in Word and I want to send a mail merged email with an
attachment
- but there doesn't seem to be a function for this. My source file is a
list
as an Excel Worksheet, and I want to send a word document attached to
emails
to all the email addresses on the list. I've also tried importing the XL
list
into my Outlook address book but it's not letting do it because I've not
defined a 'range' in the XL file - I don't know how to do that eaither!! _
Help!!!

The Outlook Object model does expose the .Subject attribute so if you have a
field in the catalog or directory type mailmerge document that contains the
individual subject lines, you can access it in the same way as the
..Addressee and .Attachment.

Declare the range object mysubject

Dim mysubject As Range

and then in the With oItem construction, include

Set mysubject = Maillist.Tables(1).Cell(Counter, 2).Range
mysubject.End = mysubject.End - 1
.Subject = mysubject


--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP
"subject line in email" wrote
in message ...
this is Supriya
i found this article very informative and happend to learn a new point
today. thans for the support and help
would you help me in suggeting an option to send an seperate subjet line
for
each mail in the mail merge process. you can even check my question
logged.

"option to merge seperate subject for email in the merge" from subject
line
in email.


regards
Supriya V
"Doug Robbins" wrote:

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

http://word.mvps.org/FAQs/MailMerge/...ttachments.htm


--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP
"Noddy of Nottingham" Noddy of
wrote
in message ...
I'm working in Word and I want to send a mail merged email with an
attachment
- but there doesn't seem to be a function for this. My source file is a
list
as an Excel Worksheet, and I want to send a word document attached to
emails
to all the email addresses on the list. I've also tried importing the
XL
list
into my Outlook address book but it's not letting do it because I've
not
defined a 'range' in the XL file - I don't know how to do that
eaither!! _
Help!!!