A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Word » Mailmerge
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

mail merge email w/ attachment



 
 
Thread Tools Display Modes
  #1  
Old October 2nd, 2008, 09:48 PM posted to microsoft.public.word.mailmerge.fields
JG
external usenet poster
 
Posts: 75
Default mail merge email w/ attachment

I need to use mail merge in Word to send an email with an attachment. I want
the text from Word to show up in the body of the email plus attach another
document to the email. I have done this in Word 2003 but cannot figure out
how to attach another file in Word 2007 ... how do i do this? Thanks
  #2  
Old October 3rd, 2008, 12:47 AM posted to microsoft.public.word.mailmerge.fields
Doug Robbins - Word MVP
external usenet poster
 
Posts: 8,239
Default mail merge email w/ attachment

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

"JG" wrote in message
...
I need to use mail merge in Word to send an email with an attachment. I
want
the text from Word to show up in the body of the email plus attach another
document to the email. I have done this in Word 2003 but cannot figure out
how to attach another file in Word 2007 ... how do i do this? Thanks



  #3  
Old January 15th, 2009, 12:21 PM posted to microsoft.public.word.mailmerge.fields
jessi
external usenet poster
 
Posts: 23
Default mail merge email w/ attachment

Hi,
I''ve tried to follow your instructions, but when I run the macro I get the
message "compile error - user defined type not defined". I've made sure to
check the outlook office library box in references. I'm pretty new to macros
and I'd appreciate any help you could give me. Thanks,
Jessi

"Doug Robbins - Word MVP" 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

"JG" wrote in message
...
I need to use mail merge in Word to send an email with an attachment. I
want
the text from Word to show up in the body of the email plus attach another
document to the email. I have done this in Word 2003 but cannot figure out
how to attach another file in Word 2007 ... how do i do this? Thanks




  #4  
Old January 15th, 2009, 08:51 PM posted to microsoft.public.word.mailmerge.fields
Doug Robbins - Word MVP
external usenet poster
 
Posts: 8,239
Default mail merge email w/ attachment

Recheck again whether the Outlook Object Library still has a checkmark
against it. Almost certainly, that is the cause of the problem.

When you click on Debug in the error message, what line of code is
highlighted in yellow?

--
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

"jessi" wrote in message
...
Hi,
I''ve tried to follow your instructions, but when I run the macro I get
the
message "compile error - user defined type not defined". I've made sure to
check the outlook office library box in references. I'm pretty new to
macros
and I'd appreciate any help you could give me. Thanks,
Jessi

"Doug Robbins - Word MVP" 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

"JG" wrote in message
...
I need to use mail merge in Word to send an email with an attachment. I
want
the text from Word to show up in the body of the email plus attach
another
document to the email. I have done this in Word 2003 but cannot figure
out
how to attach another file in Word 2007 ... how do i do this? Thanks






  #5  
Old August 4th, 2009, 04:04 PM posted to microsoft.public.word.mailmerge.fields
jalluisi
external usenet poster
 
Posts: 1
Default mail merge email w/ attachment

I'm attempting to run this macro, and I'm having a problem I can't figure
out, though, and I wondered if anyone could help me figure out what was wrong.

Everything appears to run correctly. I set the data source to send 10 test
messages to my e-mail address but with 10 different attachments - in other
words, the data source has 10 rows of data, with one of my seven email
addresses in that column for every row, and a different PDF file in the
attachment column for every row. I went through the process of creating a
1-row table Directory mail merge to get the data, and then merged to a new
document, which created (properly) a 10-row table. I saved this. I merged
the original document to a new document and then ran the macro on that, and
selected the 10-row table document I created earlier. But it's sending 20
messages instead of 10. It sends the first email message to the first
address with the first PDF attached, and then a blank email to the second
address with the second PDF attached. And then the 2nd message to the 3rd
address with the 3rd PDF attached, and then a blank message to the 4th
address with the 4th PDF attached. And so on and so forth, so that the last
11 messages (some blank, some with the mail merge text) all have the 10th PDF
attached to them (and are also being sent to whatever the last e-mail is in
the list), even if the text of the email doesn't correspond to the PDF/email
address in my original data source. I've gone back and re-read the
instructions about 10 times now, tweaking the data, doing the process over
again from scratch, making sure I have done everything exactly right, and it
seems to me that I have. Does anyone have any insight into what the problem
might be?

I'm using Office 2003.

Thanks so much,

Jen

Ms. Jennifer Alluisi M.A.Ed.
Program Director
Director of Education
Custom Management Group
www.custommanagement.com


"Doug Robbins - Word MVP" 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

"JG" wrote in message
...
I need to use mail merge in Word to send an email with an attachment. I
want
the text from Word to show up in the body of the email plus attach another
document to the email. I have done this in Word 2003 but cannot figure out
how to attach another file in Word 2007 ... how do i do this? Thanks




  #6  
Old August 4th, 2009, 09:33 PM posted to microsoft.public.word.mailmerge.fields
Doug Robbins - Word MVP
external usenet poster
 
Posts: 8,239
Default mail merge email w/ attachment

It sounds like you may have a superfluous Section Break in the mail merge
main document which is merged to create the text that appear in the email
messages

--
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, originally posted via msnews.microsoft.com
"jalluisi" wrote in message
...
I'm attempting to run this macro, and I'm having a problem I can't figure
out, though, and I wondered if anyone could help me figure out what was
wrong.

Everything appears to run correctly. I set the data source to send 10
test
messages to my e-mail address but with 10 different attachments - in other
words, the data source has 10 rows of data, with one of my seven email
addresses in that column for every row, and a different PDF file in the
attachment column for every row. I went through the process of creating a
1-row table Directory mail merge to get the data, and then merged to a new
document, which created (properly) a 10-row table. I saved this. I
merged
the original document to a new document and then ran the macro on that,
and
selected the 10-row table document I created earlier. But it's sending 20
messages instead of 10. It sends the first email message to the first
address with the first PDF attached, and then a blank email to the second
address with the second PDF attached. And then the 2nd message to the 3rd
address with the 3rd PDF attached, and then a blank message to the 4th
address with the 4th PDF attached. And so on and so forth, so that the
last
11 messages (some blank, some with the mail merge text) all have the 10th
PDF
attached to them (and are also being sent to whatever the last e-mail is
in
the list), even if the text of the email doesn't correspond to the
PDF/email
address in my original data source. I've gone back and re-read the
instructions about 10 times now, tweaking the data, doing the process over
again from scratch, making sure I have done everything exactly right, and
it
seems to me that I have. Does anyone have any insight into what the
problem
might be?

I'm using Office 2003.

Thanks so much,

Jen

Ms. Jennifer Alluisi M.A.Ed.
Program Director
Director of Education
Custom Management Group
www.custommanagement.com


"Doug Robbins - Word MVP" 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

"JG" wrote in message
...
I need to use mail merge in Word to send an email with an attachment. I
want
the text from Word to show up in the body of the email plus attach
another
document to the email. I have done this in Word 2003 but cannot figure
out
how to attach another file in Word 2007 ... how do i do this? Thanks





 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 01:49 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.