Sending Emails from Access via Outlook

[Terry Lawson]

I'm sending emails from Access in batches of up to about 300 emails.



Driven by vba on a form using Outlook.CreateItem(olMailItem).

No problem at all with that, but I need to change the message occasionally in a manner that is not data driven.

I realise that I could do this by changing the code in the form (I have full access) but this seems a messy way to do it, formatting issues etc.

Is there a more subtle method say by using Word as the message editor?

Regards

Terry Lawson

[pbaldy]

One way would be to store the message in a table and provide the users with a form to edit it. Using Word is probably possible, but I haven't done it.

[Terry Lawson]

One way would be to store the message in a table and provide the users with a form to edit it. Using Word is probably possible, but I haven't done it.

.

I should have said I'm the sole user.


Are you suggesting that?

record 1 s/b "Dear" & [variable added by a subsequent query]
record 2 s/b "some more message"
record 3 s/b "even more message"
record 4 s/b "Kind Regards"
record 5 s/b "Terry Lawson"

Adding blank records between say 1 & 2 would then create blanks lines to format the beast

[pbaldy]

My first option would still be a table, with or without a form to maintain it.