#1
|
|||
|
|||
Merge Fields, Pictures and output to email (with attachment)
I have a need to do the following:
Send a unique email to multiple recipients. This email will have different information for each recipient based on info in an excel spreadsheet. One of the unique items is a picture (.jpg). This email must also have an attachment (which is the same for all recipients) Here is what I have done so far. Using MS Word & Mail Merge, I have created the body of my email message along with the unique data fields. I have also been able to add unique .jpg using the following method: http://hubpages.com/hub/IncludePicture I can complete the mail merge and wind up with the correct information for each record in one Word doc. I then have to CTRL A --> F9 to update the .jpg for each record (as directed in the above link)...but this is as far as I can get. I now copy and paste this info from the word doc into a .msg file I have created to send each email individually. As you can imaging, this is a tedious process especially with the number of recipients I have. Any help would be greatly appreciated. |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Mail Merge Fitting Text to Fields | frnk4760 | Mail Merge | 1 | 05-18-2010 04:51 PM |
Resize Email pictures in Outlook - Office 2007? | jonesnewton | Outlook | 0 | 05-16-2010 04:11 AM |
Merge fields & Drop down menu's | ShadeTree | Word | 0 | 03-09-2010 08:19 AM |
Forwarding email with attachment | braindead | Outlook | 2 | 01-14-2010 06:03 PM |
Email (as Attachment) replaced by Mail Recipient (as Text) | dcman7 | Mail Merge | 0 | 08-18-2009 08:08 AM |