adogem
asked on
How do I send a single email from outlook to multiple addressees in an excel database
I wish to send a single email to lots of addresses stored in an excel sheet. I have no idea how to set up or run macros and have been confused by stuff I have read. Can anyone help?
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I hate to sound like a divit, but how do I actually operate this macro. I have created it in outlook, but when I run it it tells me:
error
user defined - type not defined and highlights the following exert
Function ConcRange(Substrings As Range, Optional Delim As String = "", _
Optional AsDisplayed As Boolean = False, Optional SkipBlanks As Boolean =
and how do I tell it which excel doc to execute this on? etc
error
user defined - type not defined and highlights the following exert
Function ConcRange(Substrings As Range, Optional Delim As String = "", _
Optional AsDisplayed As Boolean = False, Optional SkipBlanks As Boolean =
and how do I tell it which excel doc to execute this on? etc
adogem,
That code as written actually goes into the Excel file that has the address information.
Regards,
Patrick
That code as written actually goes into the Excel file that has the address information.
Regards,
Patrick
ASKER
Ok so far so good!
that all works fine in terms of sending an email, but being the divit that I am, how do I change the" body " bit so that I can actually control and edit the email I am about to send to all these addresses.... sorry to be a bore
thanks
Adrian
that all works fine in terms of sending an email, but being the divit that I am, how do I change the" body " bit so that I can actually control and edit the email I am about to send to all these addresses.... sorry to be a bore
thanks
Adrian
Adrian,
If you could elaborate on what you want to do with the email body, I can give more specific instructions.
That said, if you are sending individual messages and customizing the body to each recipient, then a MailMerge
is a viable option...
Patrick
If you could elaborate on what you want to do with the email body, I can give more specific instructions.
That said, if you are sending individual messages and customizing the body to each recipient, then a MailMerge
is a viable option...
Patrick
ASKER
Sorry
I'll be more succinct
I wish to send out an identical email, that is a flyer for a theatre production, and I wish it to go to lots of different theatres in a database that I have in an excel doc
I have the email already prepared in outlook (edited in word)
Adrian
I'll be more succinct
I wish to send out an identical email, that is a flyer for a theatre production, and I wish it to go to lots of different theatres in a database that I have in an excel doc
I have the email already prepared in outlook (edited in word)
Adrian
Adrian,
If you already have the email written in Word, then I now urge you to go the MailMerge route. Word has a
reasonably easy to use wizard that will guide you through the process.
Patrick
If you already have the email written in Word, then I now urge you to go the MailMerge route. Word has a
reasonably easy to use wizard that will guide you through the process.
Patrick
ASKER
Patrick
you are of course right! I tried and tested it and it's just what I need. Thanks for your time mate!
Adrian
you are of course right! I tried and tested it and it's just what I need. Thanks for your time mate!
Adrian
Adrian,
I appreciate the points, but in fairness reb73 did suggest the MailMerge a few seconds before I did. In this
case, I think a split between me and reb73 would have been a more appropriate outcome.
If you agree, please use the request attention link to ask a Moderator to reopen this question, so that you can
enter a split.
Regards,
Patrick
I appreciate the points, but in fairness reb73 did suggest the MailMerge a few seconds before I did. In this
case, I think a split between me and reb73 would have been a more appropriate outcome.
If you agree, please use the request attention link to ask a Moderator to reopen this question, so that you can
enter a split.
Regards,
Patrick
ASKER
fair do's
am onto it
Adrian
am onto it
Adrian
ASKER
Thanks very much for your patience
the addresses are in Column A, starting with A1.
Open in new window