 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Outlook / Programming VBA / March 2008mailmerge / attachement / e-mail
Dear friends, I want to send e-mails with an attached file to my contacts (outlook 2003). I found the following link http://word.mvps.org/FAQs/MailMerge/MergeWithAttachments.htm and I need help on how to apply it. Or, any other suggestions will be highly appreciated. Thanking you in advance, GeorgeCY What assistance are you looking for? The article goes into quite a few details on how to implement it in Word VBA.  SignatureSue Mosher, Outlook MVP Author of Microsoft Outlook 2007 Programming: Jumpstart for Power Users and Administrators http://www.outlookcode.com/article.aspx?id=54 > Dear friends, > [quoted text clipped - 9 lines] > > GeorgeCY Dear Sue, What I need is the following: 1) I have a MS-Access database containg contacts info. 2) I need to have a mail merge document in order to send the same letter (e-mail) to all my contacts. 3) I need to send a separate (preferably using the bcc of MS-Outlook) e-mail with an attached file (the same file for all contacts). How can I accomplish that using the guidelines of the given VBBA? Ο χρήστης "Sue Mosher [MVP-Outlook]" έγγραψε: > What assistance are you looking for? The article goes into quite a few details on how to implement it in Word VBA. > [quoted text clipped - 11 lines] > > > > GeorgeCY 3) I don't understand. Why would you use Bcc on a mail merge to send a separate file, rather than attaching it as part of the code for the mail merge? That, after all, is the whole point of the given code sample. Maybe you should give us a better picture of what you're trying to do. The code sample you've chosen might not be the right one. SignatureSue Mosher, Outlook MVP Author of Microsoft Outlook 2007 Programming: Jumpstart for Power Users and Administrators http://www.outlookcode.com/article.aspx?id=54 > Dear Sue, > [quoted text clipped - 11 lines] > >> What assistance are you looking for? The article goes into quite a few details on how to implement it in Word VBA. >> > Dear friends, >> > [quoted text clipped - 9 lines] >> > >> > GeorgeCY Thanks a lot Sue for your prompt reply, 1. I have a lot of contacts in my Outlook contacts. I need to choose some of them in order to send them a file (document file - promotional parts) every now and then - the file will be the same for all recepients. In some cases I may choose more and in some cases less contacts - most of the will be the same. 2. I don't want them (the recepients) to see the rest of the recepients - that is why I need them all in the bcc. 3. I thought that it would be much better if I have those contacts in an Access database, so using a query to select, when I want, to whom the e-mail will be sent. Is it clear now? Any ideas will be highly appreciated. Thanking you once again, GeorgeCY Ο χρήστης "Sue Mosher [MVP-Outlook]" έγγραψε: > 3) I don't understand. Why would you use Bcc on a mail merge to send a separate file, rather than attaching it as part of the code for the mail merge? That, after all, is the whole point of the given code sample. Maybe you should give us a better picture of what you're trying to do. The code sample you've chosen might not be the right one. > [quoted text clipped - 27 lines] > >> > > >> > GeorgeCY Trying to maintain data in two locations is a recipe for inaccuracies. Why not keep data in Outlook and either select the items one-by-one or select them using a category? You can then write code in Outlook VBA that uses Application.ActiveExplorer.Selection to iterate the selected items and create an individual message to each recipient. That's far more likely to get through any spam filter than sending a Bcc message. SignatureSue Mosher, Outlook MVP Author of Microsoft Outlook 2007 Programming: Jumpstart for Power Users and Administrators http://www.outlookcode.com/article.aspx?id=54 > Thanks a lot Sue for your prompt reply, > [quoted text clipped - 50 lines] >> >> > >> >> > GeorgeCY |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.