| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
kindly help me w/mail merge in xcel;40recipients1 text
I have 40 recipients to send one mail to. kindly guide how can i avoid the
laborious of treating it on 1 on 1 basis otherwise. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
kindly help me w/mail merge in xcel;40recipients1 text
Hi Taha
Do you want code ? Do you want to send text or a attachment to the 40 recipients ? Which mail program do you use ? -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Taha" wrote in message ... I have 40 recipients to send one mail to. kindly guide how can i avoid the laborious of treating it on 1 on 1 basis otherwise. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
kindly help me w/mail merge in xcel;40recipients1 text
Hi Taha,
Use Mail Merge in MS Word with Excel as the database. See http://www.mvps.org/dmcritchie/excel/mailmerg.htm Although this is for labels it works the same for letters. Everything unique for each letter must be on the same Excel row. A nice feature of filtered lists is that if you use a filter only the filtered rows will be used. Excel does not do letters by itself. If you do not have MS Word then use John Walkenbach's http://www.j-walk.com/ss/excel/tips/tip92.htm but that would be only if you don't have Word. Well I saw "Mail Merge" on the subject line, which was not included in the question. If this is for email then you would want to look at Ron's pages, and he was assuming email Generally the routines would use your email application, so don't know why he asked before giving offering a suggestion. http://www.rondebruin.nl/mail/add-in.htm http://www.rondebruin.nl/sendmail.htm -- HTH, David McRitchie, Microsoft MVP -- Excel My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm "Ron de Bruin" wrote in message ... Hi Taha Do you want code ? Do you want to send text or a attachment to the 40 recipients ? Which mail program do you use ? -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Taha" wrote in message ... I have 40 recipients to send one mail to. kindly guide how can i avoid the laborious of treating it on 1 on 1 basis otherwise. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
kindly help me w/mail merge in xcel;40recipients1 text
If you are using Office 2007, I just did an additional update
within my Mail Merge page involving Office 2007 (Excel 2007 & Word 2007). http://www.mvps.org/dmcritchie/excel...htm#office2007 that portion will still have some rough edges. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Code launches Mail Merge but disables the Mail Merge | Excel Discussion (Misc queries) | |||
| How do i suppress the message when trying to send mail from xcel | Excel Discussion (Misc queries) | |||
| mail merge excludes my headers and critical data in Word merge | Excel Discussion (Misc queries) | |||
| how do i get my mail merge to update the data source at each merge | Excel Discussion (Misc queries) | |||
| Truncation of text when using mail merge. | Excel Discussion (Misc queries) | |||
Linear Mode
