Create Outlook mail with dynamic .Body and static .HTMLBody

**Armitage2k** · 08-05-2014, 02:48 AM

Hi,

I am using the below code to generate an email from excel in outlook and add in some recipient details from the currently activate column. The email will be generated after clicking on a shape on top of the column and the recipients data should be taken from several rows in that column:

Please Login or Register  to view this content.

Now my issue is following:
1. When clicking on the shape, the cell is not activated, therefore excel doesnt know in which column I am and which rows it should take the data from.
2. The body message is taken from my "ThankYouNote_Format" sheet and is then converted to HTML. The message body is generic, but I would need the first line of the body to be a dynamic "Dear Mr. / Ms. XXX," with the data from the column's rows.

Suggestions are welcome

A2k

**john55** · 08-05-2014, 03:24 AM

see if it helps you, add the rest of yr code ...html and attachment

Please Login or Register  to view this content.

**humdingaling** · 08-05-2014, 03:29 AM

part 1

Please Login or Register  to view this content.

rename to whatever the shape is called
will give address of the top left corner of your shape

**Armitage2k** · 08-05-2014, 04:29 AM

Nope, sorry guys but all this wont work.

For one, I have about 200 copy&paste shapes, I dont want to go through all of them and assign individual macros where I have to define the shape name. When copying this 200 times I would have to rename from "shape1" to "shape200"... No thanks

For John55's sample, your date is in one row and then split among coumns, my data is in a column and then split across rows. Even when adjusting that, I run into a problem when trying to send both a HTML body as well as a regular outlook body where I just want to greet the recipient ("Dear Mr. / Ms. XXX") with data from the worksheet. Its either normal body or HTMLbody...

Thanks though

EDIT: just played around a bit with application.caller and got a good result with this code:

Please Login or Register  to view this content.

**john55** · 08-05-2014, 04:45 AM

sorry, I am not a mind reader!

Create Outlook mail with dynamic .Body and static .HTMLBody

LinkBack

Thread Tools

Rate This Thread

Display

Create Outlook mail with dynamic .Body and static .HTMLBody

Re: Create Outlook mail with dynamic .Body and static .HTMLBody

Re: Create Outlook mail with dynamic .Body and static .HTMLBody

Re: Create Outlook mail with dynamic .Body and static .HTMLBody

Re: Create Outlook mail with dynamic .Body and static .HTMLBody

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Change Font formatting mid-sentence of HTMLBody Outlook mail

Format Outlook Mail Body using VBA

Excel VBA outlook - Range in mail body

sending mail in outlook with image in Top center of body .

Send e-mail with image on body (.html) on e-mail manager <> outlook

Bookmarks

Bookmarks

Posting Permissions