Search results for query: *

Sorry for the delay in replying but by way of follow-up the answer to this problem was that those 2 machines didnt have the right service pack installed. I downloaded the necessary and now they ALL work fine! Thanks anyways mate for all your efforts.

This is the reference to the image that I use: "<img src='cid:SomePicture.jpg' height=480 width=500>" which is attached. Do you require more info? As I say, it only fails on a couple of machines - the rest are OK and when the mail comes back, the image appears all of a sudden! Strange....

...some extra info if it helps. When the email comes back from the original recipient, the image appears! Weird huh....

Ian I've come across a slight headache - on some users machines the images aren't displayed in the email. On the majority it's fine. Could this be down to the vageries of FSO? I've tried comparing the settings on everyones Outlook and nothing obvious has jumped out at me. Any ideas mate?

Ian that you link you provided was invaluable. I used the code that attaches the images to the email together with manipulation of the original HTML and that did the trick. Using the FileSystem object was a master-stroke! Thank you ever so much for your efforts. Your input was invaluable...

John thanks for your reply but I disregarded this method some time ago as I dont want to send it as an attachment. The bugbear is always retaining the formatting so I quite literally want to automate the process of opening the doc and going: File->Send To->Mail Recipient.

It's possible to open a Word doc, go: File->Send To->Mail Recipient and send the doc as an email. Can I automate this from Access using VBA? Pls also see related thread: thread705-1289920

In the interests of consistency and by way of follow-up please see the link to a thread of mine of a similar nature: thread705-1288963

Ian sorry for the delay in replying but this is fantastic!! Works a treat and well deserves a star! Just one small fly in the ointment if I may: my Word doc (which I save as an HTM file) contains a picture which although transfers into my email OK, doesn't appear at the recepients end. Any...

...could I automate this so that I could do the following: 1) Open Word 2) Select "File-SendTo-MailRecipient" (from code) or would the user have to do any of this manually?

No I'm working within a database and they want to be able to choose a doco that they've written before and then have this text displayed in the body of an email (also includes pictures) all at a click of a button. I can insert the picture using HTML but then the rest of the doco (text) comes...

...can anyone else help with this? It's proving very difficult.

Thanks for your reply KJV. Just a little more background - I'm trying to copy the contents of a Word doc and paste it into an email, from within an Access procedure. I'll take a look at the Help file.

Is this possible in code and if so how do you do it? I can get the text no problem; pictures are a different kettle of fish.

No worries Ian. I've happened another issue; can you keep the formatting of the Word doc and paste it into the body of an email?

OK this worked: Dim varWordContents With objWord .Visible = True .Documents.Open (<path>) .Selection.WholeStory .Selection.Copy varWordContents = .Selection.Range.Text End With Ever get the feeling you're talking to yourself....?!

...which doesn't work by the way.

OK so far I've got: With objWord .Visible = True .Documents.Open(<path>) .Selection.WholeStory .Selection.Copy strBody = .Selection.Paste End With Can someone please give me the last push!!!???

...also by way of follow-up the numpty who developed it used: Form.Refresh rather than: Me.Refresh which I changed it too and it worked!!

Thanks for your reply Ian. I figured this was the process but I'm stumped on the second part; would the syntax look something like this: objWord.Text = strText