By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,204 Members | 1,360 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,204 IT Pros & Developers. It's quick & easy.

Sending multiple attachments in one email to multiple address

alpnz
100+
P: 113
Hi,
I have a need to send snap reports to various shipping agents.
E.g.

A PalletCard, A FreightNote, A Consignment Advice, and an Export declaration of Conformity.
It is easy enough to code a sendobject event for a button click, however this results in One email for each object, and it is named as per the report name. What I would like to achieve is One email with multiple attachments, which we send to a Contact Group in Outlook.

So I would like this to happen.
  1. Name the attachment E.g. Pallet1234.snp, etc etc for each report I want to send. (The 1234 is a field in the Pallet Table.)
  2. Group the attachments onto one email,
M$ is not entirely helpful on this subject, but surely the tools are there. Has anyone achieved this in the Past ... hint hint Mary
Dec 23 '06 #1
Share this Question
Share on Google+
8 Replies


MMcCarthy
Expert Mod 10K+
P: 14,534
I doubt if sendobject can handle this as it's designed to send one object. I would guess we will need to use automation to outlook (in other words a lot of code). Post a reply to this thread on Wednesday or Thursday to remind me and I'll have a look.

Merry Christmas.

Mary

Hi,
I have a need to send snap reports to various shipping agents.
E.g.

A PalletCard, A FreightNote, A Consignment Advice, and an Export declaration of Conformity.
It is easy enough to code a sendobject event for a button click, however this results in One email for each object, and it is named as per the report name. What I would like to achieve is One email with multiple attachments, which we send to a Contact Group in Outlook.

So I would like this to happen.

  1. Name the attachment E.g. Pallet1234.snp, etc etc for each report I want to send. (The 1234 is a field in the Pallet Table.)
  2. Group the attachments onto one email,
M$ is not entirely helpful on this subject, but surely the tools are there. Has anyone achieved this in the Past ... hint hint Mary
Dec 25 '06 #2

alpnz
100+
P: 113
I doubt if sendobject can handle this as it's designed to send one object. I would guess we will need to use automation to outlook (in other words a lot of code). Post a reply to this thread on Wednesday or Thursday to remind me and I'll have a look.

Merry Christmas.

Mary
Did you have a good Xmas, Hope so, cause this problem is not an easy fix I think. My Partners brother, tells me it is better to use a pdf creation product like Adobe, and build them outside of Access, but surely we don't have to resort to this.
Dec 28 '06 #3

NeoPa
Expert Mod 15k+
P: 31,494
I have found Snapshots and the Snapshot viewer to be unreliable in various circumstances.
I don't use it any more :(.
Dec 28 '06 #4

alpnz
100+
P: 113
I have found Snapshots and the Snapshot viewer to be unreliable in various circumstances.
I don't use it any more :(.
OK,
One suggestion from an associate is that we use a PDF creator, to write the reports to. Have any of you implemented anything like this in the past?
Dec 30 '06 #5

NeoPa
Expert Mod 15k+
P: 31,494
I use that now.
I create the report normally and print to the Adobe printer which converts the print output to a PDF file.
Dec 30 '06 #6

MMcCarthy
Expert Mod 10K+
P: 14,534
OK,
One suggestion from an associate is that we use a PDF creator, to write the reports to. Have any of you implemented anything like this in the past?
I have but it's been a while. If noone else answers this with code I'll try to find the procedure. May take a while.

Mary
Jan 1 '07 #7

alpnz
100+
P: 113
I have but it's been a while. If noone else answers this with code I'll try to find the procedure. May take a while.

Mary
Yes the printing to an Adobe Printer is understood, but what is not clear to me is the consolidation of a number of reports into one report, or do I just use the PDF printers options??.
Jan 1 '07 #8

MMcCarthy
Expert Mod 10K+
P: 14,534
Yes the printing to an Adobe Printer is understood, but what is not clear to me is the consolidation of a number of reports into one report, or do I just use the PDF printers options??.
Essentially you would add each report to the pdf as a new page or pages. This would require some kind of loop.

Mary
Jan 1 '07 #9

Post your reply

Sign in to post your reply or Sign up for a free account.